TRY TO MAKE TEXTBOX AS REQUIRED FIELD

[JOHN]

Hi,
I have testbox controls in the form which bound to the
table fields. The form is used for data entry. How do I
make those textbox controls as required field -- user
must key in information before leave a textbox.

Thanks
John

 

[kevin watkins]

John,

It works best if you set the value in required in the
design view of the table to yes. This will mean that any
form that is tied to this field will require input. Look
in the northwinds database and check the catagories table
and then the catagories form. You'll see there how that
requires data in the catagory name field. In the table
that field is set as required.

Kevin

 

[John]

Thank you for your reply.

I did what you want me to do. and it do not work. I go to
the sample. it exactly did what you said. I do not know
wha is wrong with mine. any idea?
I am on access 2002. the sample I looked is 97 access.