Change Format of a Control

  • Thread starter Thread starter Rhonda Floyd
  • Start date Start date
R

Rhonda Floyd

Is there a way to change the format of a control on a form?

I have a key field (txtKey)

if txtkey = 1 then txtRangeFrom should become a Date with Inputmask = 99/99/00;0;" "

if txtkey = 2 then txtRangeFrom should become alpha with Inputmask = >C

I'm using Access 97.

Any help will be greatly appreciated.

Thank you,
Rhonda
 
Rhonda said:
Is there a way to change the format of a control on a form?

I have a key field (txtKey)

if txtkey = 1 then txtRangeFrom should become a Date with Inputmask =
99/99/00;0;" "

if txtkey = 2 then txtRangeFrom should become alpha with Inputmask =

I'm using Access 97.

Any help will be greatly appreciated.

Thank you,
Rhonda
Click to expand...


One possible solution would be to have two text boxes, formatted
appropriately and placed on top of each other. Then depending on the
value of your txtkey, make the appropriate one visible.

hth

Hugh
 
Rhonda said:
Thank you Hugh, that works great!




One possible solution would be to have two text boxes, formatted
appropriately and placed on top of each other. Then depending on the
value of your txtkey, make the appropriate one visible.

hth

Hugh
Click to expand...


You're welcome - I'm glad you got it working the way you want.

Hugh
 
Back
Top