finding it impossible for input mask to work

[Zariah]

I need to create an input mask and format property as follows:
Input mask - 3 characters, allows digit or space(entry not required, plus
and minus signs not allowed; and specifies 'x' as teh character that
Microsoft access displays for the space

Format property
specifies the format for positive numbers as digit placeholder that display
a digit or 0....output should show leading zeros

Have got it half right but cannot get perfect, any help appreciated

 

[Van T. Dinh]

1. If you use only letters (a-z) and digits (0-9), then you can use the
InputMask "aaa".

2. I am not sure what you meant about the "x".

If you want use "x" as the *placeholder*, i.e. before the use types the
character, then simply specify "x" in the 3rd section of the InputMask.

If you want to display "x" instead of the {space} character entered by the
user, then this is not a function of InputMask (more of format, I think).

3. Not sure your description of the need format. Note that it is like to
be a Text value, not Numeric since you allow letters. Then you will also
take into account of the above "x" which adds complication.

 

[Zariah]

thank you.....I will try and see if I can sort it out.
I have one more enquiry. I need to specify the following for a column -
1. the user's input is checked so that if the user enters a value then that
value must be 0 through to 100(inclusive)

Hope that makes sense. Trying to build this database but am quite new to it
all.
Cheers
Zariah

 

[Zariah]

Hi again

In regards to the first question, I also have to make sure the user's input
is checked so that the field only allows the values 1 through to
999(inclusive)

Thanks again
Zariah

 

[John Vinson]

Hi again

In regards to the first question, I also have to make sure the user's input
is checked so that the field only allows the values 1 through to
999(inclusive)

Set the field's Validation rule to

0 AND <1000

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Van T. Dinh]

I am rather confused by your requirements. You want to allow letters which
means Text values but you want to check / validate numeric values.

OTOH, you only allow up to 3 letters / digits so the "number" (IF the entry
contains only digits) cannot exceed 999 (unless the 2nd character happens to
be a "D" or an "E". If you don't know about this, don't worry.).