mask a textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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...
 
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...
 
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...
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
TextBox to Array, Array Displayed in Textbox 0
Input Mask query 3
List Box that populates Values and provides a total in a Report 1
Why The Result Show Like 00:00, Access 2007 2
Adding minutes 14
Input Mask in tables 2
Remove input mask format 4

Back
Top