Validation to not accept numerical characters

[Zholt]

Hi,

Basically i need to know what the validation code would look like to only allow alpha characters ( a-z and A - Z),


I have absolutely no knowlege of VB and that is all that i can find when searching,

Thanks
Zac

 

[Galaxiom]

Go for the VBA. It isn't as hard as it looks at first. and is an essential part of designing in Access. When you use a validation rule at table level you get the standard message. Do your own and you control the behaviour and appearance completely.

To add code to a control is easy. For example, in the box you are validating go to the On Change event property and click the (...) and choose Code Builder.

The VBA Editor opens. Put the VBA solution in between the lines automatically created.The code here will run when the contents of the textbox changes.

There are lots of other events. Choose whatever works with the code you find as appropriate.

 

[Zholt]

Im having a slight problem loading up VB, i am using 2007 and when i click the visual basic button it loads but no objects/files are there nor is there any auto generated text as you mentioned above

 

[Galaxiom]

Go in from the properties window of the control on the form.

Right click the textbox and turn on properties. Go to the events tab and choose the event as described in my first post.