Entering '0' in a field.

[barretc]

Hey,

I am creating a form and one of the fields are 'Area Code'. Input will be along the lines of 02 and 03, but whenever I do this it deletes the 0, just leaving a 2.

How do I make access leave the 0 in the field?

Thanks.

 

[RuralGuy]

Change the field in the table to a Text field rather than a number.

 

[barretc]

Thanks RG,

I'm also looking to predefine the size of a text box.

I.e. I want a text box to contain maximum 2 characters. After 2 characters a user won't be able to enter in any more.

Thanks.

 

[RuralGuy]

Have you tried setting the field size in the table to two characters? You may want to deal with this in your form so you have more control over the user interaction.

 

[barretc]

Thanks again RG.

 

[RuralGuy]

Glad to help.