dbTalk Databases Forums  

Contains a Default Value but need Form Validation

comp.database.ms-access comp.database.ms-access


Discuss Contains a Default Value but need Form Validation in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tina Marie
 
Posts: n/a

Default Contains a Default Value but need Form Validation - 11-12-2003 , 10:43 AM






Hello,

I need your help. I am creating a database for work and have run into
a problem...

I am in the process of creating a form. In one of my fields called
Asset_Num I have put a defalut value of `BC` because I would like this
to appear by default for the user in the field. I have an input mask
of LL00000 so that BC is already entered and then the user just has to
enter 5 numbers. I have also put a validation to the effect of: Like
`BC and 5 questions marks to show that it should contain 7 characters.
This field is a primary field and is required. Though this
validation does not prompt an error..

The problem is when the form opens up it adds the BC to the field
which I want but then I can tab to the next field without it giving me
an validation error. I would like it to force me to enter the 5
numbers to the characters already displayed before letting me move to
the next field.

Thank you for your help...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.