save input with space at the right position (postal code)

[frankmanl]

In my input form I use a field for the postal code. The dutch postal code is like "1111 AA"


For this form field I use an input mask "0000\ >LL" which shows the desired result in my form.
But my input is stored in the table as "1111AA".
How can I get the space between the numbers and the characters in my table?

BTW: The field in the table has no mask whatsoever.

Frank

[isladogs]

If the postcodes ALWAYS follow that pattern , use an update query

UPDATE YourTableName SET YourTableName.Postcode = Left([postcode],4) & ' ' & Mid([Postcode],5);

[Welshgasman]

Can't you just adjust it in the AfterUpdate of the control?

[xps35]

How can I get the space between the numbers and the characters in my table?

Why should you want that if it is OK on the form?
If you want, you can apply the same mask to the table.

[CJ_London]

there is a setting where the input mask format can be saved to the underlying field

https://learn.microsoft.com/en-us/of...tbox.inputmask

[frankmanl]

Thank you for all your replies.
I use an export of the table to create mailinglists, so that is why it's important the data are stored with a space betweennumbers and characters.
Applying the same mask to the table field is the right solution for me, thank you Peter.
Frank

[CJ_London]

that is why it's important the data are stored with a space

di you are happy to kid yourself that what you see is what you’ve got?

if you see ‘1234 AB’ how do your know it is not actually stored as ‘1234ab’. If you never need the field for criteria, filtering or sorting, probably won’t matter but why kid yourself?

[frankmanl]

Oh, I see what you mean: it is still stored as 1234AB - without the space.
The right solution seems to be:
• no mask for the table field
• mask for the form field is now "0000\ >LL;0;_"
The zero after the first semicolon makes the data to be stored as displayed by the mask: with a space between the numbers and characters.
Thank you CJ, for pointing this out.
Frank

[Welshgasman]

Thank you for all your replies.
I use an export of the table to create mailinglists, so that is why it's important the data are stored with a space betweennumbers and characters.
Applying the same mask to the table field is the right solution for me, thank you Peter.
Frank

In which case you could format it as you wish?

[CJ_London]

Deleted