validation

[canablitz]

hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

BoB

[Ivan F Moala]

On 2002-03-18 01:39, canablitz wrote:
hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

BoB

Hi Bob
The textbox has a property
Maxlength....set this to your max length.

To view the textboxs propetties
Just press F4 while in the VBE editor


HTH


Ivan

[Craig AS]

hello

I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

thnks alot Craig

[Ivan F Moala]

On 2002-03-18 01:53, Craig AS wrote:
hello

I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

thnks alot Craig

Basically
Use a seperate sheet to record there details
Hide this sheet.
Use workbook open & a userform to get
the info and do a check against the data
you have in the hidden sheet.

There are a lot of ways to do this.....
have a go @ trying to do this.
If you get stuck then repost with your problem and I'm sure
someone will help


Ivan