Required fields in forms

[jbelf]

Hi,

is there a way to make a form field required? I am aware I can make it required at the table level, but I am creating several forms for this database, some forms need to have required fields, but other forms do not - the all write to the same table.

I found the validation bit - but am not sure how to use it or if this is the right way to go.

any insight greatly appreciated.

 

[BobJacksonNCI]

It is the right way to go.

In Access Help, find the documentation by selecting
Index, then typing validation.

In the "Choose a topic" box, double-click
ValidationRule, ValidationText properties.

Pay attention to the part about null fields.
You need to know what the table allows to set this
correctly.

Bring up the form in design view, right-click the
field (also know as a control) and select properites.

Under the "Data" tab you'll see
Validation Rule
and
Validation Text

Load those appropriately and you should be set.

For a detailed response for one control, provide
the validation you're looking for and the table
definition for the field and someone here can assist.

HTH,
Bob