Microsoft Access 2000

[NickleArse]

If I have a text field in a table is it possible to have a validation rule to ensure the field contains no spaces?

[rinkytink]

What sort of data will be going into this field ? Will it always be the same length ? Also will data entry be via the table or from a form ?

[NickleArse]

It will be vehicle registration details. So will not always be the same length (Private Plates etc...). It will be inputted via a form. I thought I would have a problem with reports searching for a registration if some people used spaces and some didn't but it seems to be working ok???

[rekstout]

It is simpler to do this in VBA

Paste this code into the BeforeUpdate Event code window...

If IsNull(txtReg) Then
Exit Sub
End If

If InStr(1, txtReg, " ") > 0 Then
MsgBox "Please do not include spaces ", vbOKOnly, "Invalid Reg Number"
Cancel = True
End If


Adjust txtReg to be whatever you named that field and that should do the trick for you

[NickleArse]

Thanks rekstout. I am no expert at VBA but your answer makes sense, I will give it a try. Cheers

[NickleArse]

Yep, tried it and it works a treat. Thanks again.

[rinkytink]

You could also try this... Create an event procedure for the on key press event for the text box on your form. Paste in this code (where test1 is the name of your text box) Private Sub test1_KeyPress(KeyAscii As Integer) If KeyAscii = 32 Then Beep KeyAscii = 0 End If End Sub

[rinkytink]

Sorry if that appears a bit jumbled !! Hope you get the gist of it !!

[NickleArse]

Ok, thanks Rinky Tink