Input Mask

[Khalil Handal]

I have a text field on a form, I want the values to be saved in the table without any spaces in it. The size of the field is 17
On the reports and forms I want to use an input mask that reserves the position of each character.
On the Form / Report, I want to have a point (.) after each three character, The tenth character is a space. After the tenth character I might have three and some times four letters followed by another space and the 2 or 3 letters or digits.


The first nine positions are only digits, in some cases I might have the first three digits and then I will move to the eleventh position which is a letter.

What input mask should I use for this?
What VBA should I use in the Lost focus or After Update event to remove the spaces if used when entering values by the user?

Example:
Value is: 395.09. ABC 12 or 395. 09. ABCD ind
saved is table as: 39509abc12 saved as: 39509ABCDind

Khalil

[CJ_London]

don't think an input mask will work in this case because of the varying number of characters after 'abc'

suggest use the afterupdate event to remove both spaces and dots

vba would be

myfield=replace(replace(myfield,".","")," ","")

[NTC]

the replace method does work well when there are unexpected spaces.....but it seems like you want to do a lot more than control just spaces so

you might also consider a separate field (either bound or unbound) for each section/segment of this string. that way you can then merge together as you wish - - plus manage each section via mask independently....

[Khalil Handal]

Thank you both for your reply.
Space is one part for the issue and I think I also might need to separate it to more than one putting into consideration the position of the ( .) for each part.

Khalil