Conditional Text Box Format

[NeonSky via AccessMonster.com]

Good Day,

I am looking to create a conditional format on the input value within a text
box.

The form where this text box resides simply has a single text box, and a
button. When the user inputs a single numerical charcter (1-9), when the
button is clicked I would like this character to be updated to a double digit
01, 02, 03. Furthermore I would like to limit the number of characters that
the box can contain to "2" characters.

Thank you!

 

[NeonSky via AccessMonster.com]

I am sorry I did not mean to post twice, is there a way to delete one of
these posts?

 

[MGFoster]

I am sorry I did not mean to post twice, is there a way to delete one of
these posts?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not a query question, but I'll answer anyway ;-)

Limit to 2 characters: In the TextBox's Input Mask property put this:

Input Mask: ##;;_

Leading zero, when necessary: Then in the TextBox's Format property put
this:

Format: 00

That's 2 zeros.

This number will be stored in the table without the leading zero if it
is less than 10, but will be displayed with the leading zero when shown
in this TextBox. If you want it to always show w/ a leading zero set
the table design column's Format property to 2 zeros, also.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdPkqoechKqOuFEgEQIrhACfcoH5ytCzG1c/oPJqJNCRA3V3r1YAn1+6
rm0BHk3UAAKRZe4kr7CDoIos
=/tx4
-----END PGP SIGNATURE-----

 

[NeonSky via AccessMonster.com]

Thank you for the informative response!

I am sorry I did not mean to post twice, is there a way to delete one of
these posts?

[quoted text clipped - 8 lines]
Not a query question, but I'll answer anyway ;-)

Limit to 2 characters: In the TextBox's Input Mask property put this:

Input Mask: ##;;_

Leading zero, when necessary: Then in the TextBox's Format property put
this:

Format: 00

That's 2 zeros.

This number will be stored in the table without the leading zero if it
is less than 10, but will be displayed with the leading zero when shown
in this TextBox. If you want it to always show w/ a leading zero set
the table design column's Format property to 2 zeros, also.