Brian Pearson
My feedback
-
4 votesBrian Pearson
supported this idea
·
-
9 votesBrian Pearson
supported this idea
·
-
2 votes
An error occurred while saving the comment -
13 votesBrian Pearson
supported this idea
·
-
2 votes
An error occurred while saving the comment Brian Pearson
commented
Surely a textbox's CanGrow property provides this functionality?
-
28 votesBrian Pearson
supported this idea
·
-
9 votesBrian Pearson
supported this idea
·
-
24 votesBrian Pearson
supported this idea
·
-
4 votes
An error occurred while saving the comment Brian Pearson
commented
After you've drawn the line, if it's not horizontal, just set its Height to zero in the Properties box.
Bingo; horizontal line.
-
11 votesBrian Pearson
supported this idea
·
-
7 votesBrian Pearson
supported this idea
·
-
1 vote
An error occurred while saving the comment Brian Pearson
commented
Lightwave
I have to say that I think the tag property is something different from your suggestion. Tagging would allow any kind of alphanumeric string to be set for these objects, not just a unique numerical key. Also you can change the tag whenever you want.
Brian Pearson
supported this idea
·
-
2 votesBrian Pearson
shared this idea
·
-
6 votesBrian Pearson
supported this idea
·
Access can certainly handle problems like this.
Put your 'Progress types' into a separate table (it's not clear but maybe you've already done this). In that table, you'll have at least an ID (ie autonumber) field,.a description field (eg 'Not started') and a Sort order field ('2' in this case).
In the base table, you'll associate each record with the ID field of the Progress types table. In the report, you'll sort using the [Sort order] field of that table. You can actually use multiple sort fields if you want to. Go to the 'Sorting and grouping' settings of the report to do this.