Mask EdBox

[dvannoy]

i am using a mask text box on a form and am trying to figure something out.

if i set the mask to ##/##/#### it works fine.

now if a user has to go back and edit that field it will not work correctly. by setting the mask I only want two digits before the first /.. but if i call the recordset to the form and try setting the mask field with txtbox = rs.fields("fieldname&quot it ignores the mask..and will not force the two digits before the first /..it will take as many digits as you enter.

I hope this makes sense..

Thanks in advance

 

[Razvi]

Hi dvannoy
Could you post the code.
Thanks,
Razvi

 

[vikram28]

Try this

1. First
maskEdBox.promptinclude = false
2.Then
maskEdBox1.text = whatever

 

[CCLINT]

Try using:

txtbox.Text = Format$(rs.fields("fieldname&quot,"!@@/@@/@@@@&quot

or:

txtbox.PromptInclude = False