Validation rule of 6 digits in an Access Database Attribute

[RobertSmith101]

I would like to know how I could ensure that onnly 6 digits were input into my CustomerID attribute. (I have Access 2002 and its not as simple as Access 2000) I need a error box to come up when (6 isn't entered) in datasheet view and the data form view.

 

[Dugantrain]

I haven't used Access 2002, but it seems like the code should be the same:

YourControl_BeforeUpdate(Cancel as Integer)
if len(me.YourControl)<>6 then
msgbox "Tell User that he screwed up"
me.YourControl.undo
Cancel=true
end if
End Sub

 

[RobertSmith101]

Thanks for the help however could you tell me where I am to put this?

 

[Dugantrain]

Yes, in Design view, right-click on the Control in question and then, under Properties->Events->On Before Update->Code Builder and then this will pop up:

YourControl_BeforeUpdate(Cancel as Integer)

End Sub

You'll have to fill between the lines with the appopriate logic (Replace YourControl in my generic code with the name of the control in question).

 

[RobertSmith101]

Thanks I got it working now.