Hello all,
I am having an issue with an input mask not working correctly. I have a text box that has an input mask 0000\-00;0;_ which displays as, for example, ____-__ so a user can put in a number like 1234-56. If I type in a number manually, it works fine. Puts it into the table as 1234-56 but if I populate that field through VBA it doesn't. I populate that field with just straight numbers like 123456 and then it display in the text box 1234-56 but goes into the table as 123456. I tried putting an input mask in the table field itself and it shows it as 1234-56 but does not exactly do what I need it to do. I have code other places (not written by me
) that is looking for that "-". So, it seems like it is not recognizing the "-" and then doesn't work.
I am using Access 2003
Can someone please direct me in the right direction with this one.
Thanks,
Stoss
I am having an issue with an input mask not working correctly. I have a text box that has an input mask 0000\-00;0;_ which displays as, for example, ____-__ so a user can put in a number like 1234-56. If I type in a number manually, it works fine. Puts it into the table as 1234-56 but if I populate that field through VBA it doesn't. I populate that field with just straight numbers like 123456 and then it display in the text box 1234-56 but goes into the table as 123456. I tried putting an input mask in the table field itself and it shows it as 1234-56 but does not exactly do what I need it to do. I have code other places (not written by me

I am using Access 2003
Can someone please direct me in the right direction with this one.
Thanks,
Stoss