restrict null and space

[JIM.H.]

Hello,
I have a number field, how can I restrict null and space entry? When it
happens user should see an error message.
Thanks,
Jim.

 

[John Vinson]

Hello,
I have a number field, how can I restrict null and space entry? When it
happens user should see an error message.
Thanks,
Jim.

Set the Required property of the field to True in table design view.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps