Require Field Entry

[Guest]

Is there a way to set up the properties of each field so that an entry is
required by the data entry person? I have fields that are combo boxes, but I
notices in my testing phase that if I tab to fast I miss the last field and
go into the next record. Houw do I require an entry so that an error message
will appear is the field is not given a selection based on the combo field?
I have the properties as limited to list.

 

['69 Camaro]

Hi, Lynette.

Houw do I require an entry so that an error message
will appear is the field is not given a selection

Open the table in Design View and scroll down to the column name, then
select the "Required" Property in the lower pane and change it from No to
Yes. Save the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joan Wild]

In the table, set the required property of the field to yes.

 

[Douglas J. Steele]

Put logic in the form's BeforeUpdate event to check that every required
field has a value. If it doesn't, flash up an error message, and set Cancel
= True.