Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[b]How to make required fields highlighted[/b]

Status
Not open for further replies.

chasmith17

Technical User
Joined
May 25, 2006
Messages
47
Location
US
Hello,
Can anyone tell me how to make required fields in forms highlighted and to change the standard Microsoft Access error message when that field is null? Thanks in advance.
 
I know, I know, I messed up on the subject line. sorry
 
How are ya chasmith17 . . .
chasmith17 said:
[blue] . . . how to make required fields in forms highlighted . . .[/blue]
in form design view just select the backgroung and/or foreground colors you like and save the form.
chasmith17 said:
[blue] . . . change the standard Microsoft Access error message when that field is null?[/blue]
If you've set required in the table(s) you can't. You'll have to perform your own validation using the forms [blue]BeforeUpdate[/blue] event . . .

Calvin.gif
See Ya! . . . . . .
 
Thanks TheAceMan1,
I wasn't thinking on the first question and then after I posted the thread it came to me but thanks for the information on the validation question, I will give that a try.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top