format of a field

[bunji]

I have changed the inputmask of a field based on an if statement. however i put / characters in place and it wont leave them there can anyone help.

Me.txtbox = "AAAAA/AAA/AA"

 

[ghudson]

What do you want the input mask to do?

What do you want it to force the user to key?

/ are usually with date.

 

[bunji]

I already have

Me.AF_Approval.InputMask = "AAAAA/AAA/AA"

But when the user exits the field it goes to

AAAAAAAAAA

I would like to keep the foward slashes.

 

[ghudson]

Put this in the input mask field

AAAAA/AAA/AA;0;_

The ;0 means that you want to store the slashes in the table. The ;_ is the place holder the user will see when they are typing in the field.

AF_Approval.InputMask = "AAAAA/AAA/AA;0;_"

That extra info is in the help section for input masks.

 

[bunji]

Thanks that worked

 

[ghudson]

you are welcome