Adding a leading zero(0) to field

[accessuser2023]

Hi All,

I have a field that contains a social security number. If only the last 4 digits are provided, I fill the leading spaces with zeros manually. However, is there a 'simple' way, perhaps with a little code, to have those leading spaces automatically filled in with zeros so I do not have to type them in manually.

Thanks for your help!

[June7]

Assume this is a text type field.

Yes, code can add leading zeros to value when committed to table.

Or format field to only display additional zeros when needed. This may be the simpler approach.

Format([SSN],"000-00-0000")


Review:
https://stackoverflow.com/questions/...0for%20display.

Storing Social Security Numbers and Credit Card Information (microsoft.com)

[accessuser2023]

Perfect that makes sense thank you!

[accessuser2023]

This may sound stupid, but this totally worked yesterday but for some reason now in the format property the it is showing up like this : "For"m"at(["ssn"],000-00-0000)

Am I missing anything?

[June7]

Can't use in Format property. This would be an expression used in a query or textbox.

Might be able to use Format property but then would not use Format() function.


I do not have Access available now to test.

[accessuser2023]

If using the format property, would it just be 000000000 or something else? I have an input mask that places the dashes (000-00-0000) when typing in a social. Thanks!

[June7]

I think InputMask overrides Format.