Formatting a field

[Darla123]

Hello, is there a way to format a field to only allow a date OR the values "IN" and "OUT"? We want people to be able to enter a date or I/O but nothing else.

[jimatqsi]

It is not field formatting you have to deal with but form validation. Put this in the Validation Rule for the text box you are concerned with:

IsDate([TextBoxName])=True Or "IN" Or "OUT"

You may also want to put something particular in the ValidationText property. This is the message text that will be displayed if the user puts an improper value in your text box.

Jim

[Darla123]

This works great, thank you so much! I am really learning a lot about access from these boards.

[jimatqsi]

Me too, Darla, I still learn something new about Access every day. So glad I could help.

Jim

[Darla123]

One last question, how do I build date formatting into this? Like the date can only be M/DD/YY?

[jimatqsi]

Now you're talking about formatting. On the formatting tab of the properties you can specify mm/dd/yy for the display format. But elsewhere, reports and other screens, you'll have to display the formatting there also.

[Darla123]

Don't I feel silly now!! Thanks again!