Input Mask Problem

[maya]

Hi ive formatted the input mask for this textbox as R3- and it must be followed by some text that the user keys in themselves...
the problem now is that the R3- appears in the textbox but the user can add the text after that...what should be done? Thanx

 

[namliam]

If you are using a format then you must fill it compleetly... a format "R3-" Will not allow any further input, you need to add something... like "R3-"CCCCC allowing for 5 additional characters

Read the help on format to get more info....

Regards

The Mailman

 

[maya]

thanx, i know how to solve it alredy...in the properties under input mask i entered "R3- &&" to let the user key in 2 numbers after R3

 

[Mile-O]

If it's just numbers then you might want to make your input mask:

R3 - 00

Currently, with R3 - && I could enter:

R3 - AF
R3 - 2
R3 - /3
R3 - ~+
R3 - ."

etc.

Using 00 will fix it to two numbers and two numbers only.

 

[maya]

ok..that will work better, thank you and have a nice weekend

 

[Mile-O]

have a nice weekend

I'll try.

 

[namliam]

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

Read the help on format to get more info....

You might want

00
99
##

Any of the above allow number in combination with + - and spaces

but Read the help on format to get more info....

Regards

 

[maya]

I realise that there is a new problem with my input mask..ive formatted it to "R3-"### to allow user to either input 1 2 or 3 numbers but the problem now is after the user has type in the number, the R3- disappears and the one only left in the textbox is the numbers the user typed in....what could be triggering it to disapear? and the value saved does not include R3-

Pls help urgently...Thanx

 

[Edski]

Why not add the following to the AfterUpdate Event for the field:

field = "R3 - " & field

 

[WayneRyan]

Maya,

When you specify a format like that it is not saved in the table
in that way. If you look at the table the data type is number.
How can it store R3 in a number?

You can specify a format for the table and/or for a form, but
that only affects the way that a table or form displays the
data. If you change the format, it only changes the appearance
of the data.

You should consider either changing it to a text field and
manipulating the "R3" yourself, or breaking it into two
fields. It is easy to put them together for forms and reports.

Wayne

 

[maya]

the data type for ths field is text but its ok ill just let them key in by themselves...its just a fuss!!