Validation

[Ashley25]

I've done some looking into how to validate in Access and I found how to do it for an entire field but I was wondering if it's possible to validate a single record in a field.

[June7]

What do you mean by 'single record in a field'?

[Ashley25]

I only want to validate the Implementation Status' description

[June7]

Validate it to what? Maybe you should use a combobox. The LimitToList property can be set to yes.

Are you the only user of this db?

[Ashley25]

Yah I'm the only one that's using this. I'm trying to teach myself about access so I can list it as a skill in future applications. What i'm trying to do is make it so the only things that can be added to the description box are "Implemented, Partially Implemented, Or Not Implemented." Is that possible?

[June7]

Yes, that is a combobox or listbox. If you want to do data entry directly on table, then set Lookup properties for the field in table. Normally I advise against this but if you want to save the text description and not an ID (1, 2, 3) should not cause issues.

However, you might find data entry into a bound form more agreeable.

Suggest you get a basic introductory tutorial book.

[orange]

There are a number of tutorials (free) regarding comboboxes here.

Good luck.