mask a textbox

M

Michalis J.

I need to make a number in a textbox appear as follows:
3 as I00003
24 as I00024
112 as I00112
Can anybody help me on this
Thanks in advance
 
T

tina

you need to use the Format property, rather than the Input Mask property, as

\I00000

you can enter the above custom format in a textbox control's Format
property, in a form or report. you can also enter it in a field's Format
property, at the table level, or in a query. note: remember that changing
the format does *not* change the value that's saved in the field, it only
changes the way the value is displayed.

hth
 
F

fredg

I need to make a number in a textbox appear as follows:
3 as I00003
24 as I00024
112 as I00112
Can anybody help me on this
Thanks in advance
Click to expand...

Set the control's Format property to:
\I00000
 
A

adsl

Michalis J. said:
I need to make a number in a textbox appear as follows:
3 as I00003
24 as I00024
112 as I00112
Can anybody help me on this
Thanks in advance
Click to expand...
 
A

adsl

tina said:
you need to use the Format property, rather than the Input Mask property,
as

\I00000

you can enter the above custom format in a textbox control's Format
property, in a form or report. you can also enter it in a field's Format
property, at the table level, or in a query. note: remember that changing
the format does *not* change the value that's saved in the field, it only
changes the way the value is displayed.

hth
Click to expand...
 
A

adsl

tina said:
you need to use the Format property, rather than the Input Mask property,
as

\I00000

you can enter the above custom format in a textbox control's Format
property, in a form or report. you can also enter it in a field's Format
property, at the table level, or in a query. note: remember that changing
the format does *not* change the value that's saved in the field, it only
changes the way the value is displayed.

hth
Click to expand...
 
Top