Validation text invisible when its needed

[Guest]

I am new to Access. I recently designed a DB for a cancer survey. In it
were questions about demographics and so on that included validation rules
such as “0 or 1†for Gender in which 0=male and 1=female. Other questions
used Likert items with more complex rules. The trouble I am having is
getting the validation text to show up automatically somewhere in the
datasheet view so that coders can see it as they enter data. I don’t want
coders to either have to violate the validation rule or toggle back and forth
between the datasheet and design view in order to know what the rule is for
each column. So, I thought this might be done in one of 3 ways:
1. Set the DB so that each time the coder hits tab the validation text shows
up.
2. Add an item to the menu bar that displays the validation text for each
cell as the coder hits tab.
3. Allow the simultaneous display of the datasheet and design views.
Does anyone have any ideas how one of these might be done? Other ideas,
perhaps? Thanks.

 

[Ken Snell [MVP]]

Do not have users enter data directly into the tables!

Instead, use a form that is bound to the table. On that form, put textboxes
that are bound to each field. Put labels above each textbox that tell the
user what the validation rule is for that "field".

 

[Apple]

I am new to Access. I recently designed a DB for a cancer survey. In it
were questions about demographics and so on that included validation rules
such as ¡°0 or 1¡± for Gender in which 0=male and 1=female. Other questions
used Likert items with more complex rules. The trouble I am having is
getting the validation text to show up automatically somewhere in the
datasheet view so that coders can see it as they enter data. I don¡¯t want
coders to either have to violate the validation rule or toggle back and forth
between the datasheet and design view in order to know what the rule is for
each column. So, I thought this might be done in one of 3 ways:
1. Set the DB so that each time the coder hits tab the validation text shows
up.
2. Add an item to the menu bar that displays the validation text for each
cell as the coder hits tab.
3. Allow the simultaneous display of the datasheet and design views.
Does anyone have any ideas how one of these might be done? Other ideas,
perhaps? Thanks.