validate field entry

[virencm]

hi

I have a field with data type "number". i need to always validate that the first number entered is a 7,if not an error message. any help would be great.

cheers

Viren

 

[MStef]

Look at "DemoValidate7A2000.mdb" (attachment, zip).
Open form and try. Look at VBA.

 

[ghudson]

Use the After Update event of the text box with something like this...

if left(YourTextBoxName,1) <> 7 then
   msgbox "value does not begin with a 7!"
   me.YourTextBoxName.undo
   me.YourTextBoxName.setfocus
end if

 

[virencm]

thank you. it works great!!!