Remove Leading Zeros (A2K SR1)

Topic

New Reply

How do I strip the leading zeros from data entered into a form field? Despite my best efforts, my users continue to add leading zeros to a particular field, which screws up the processing of subsequent reports. The field only ever contains a number, so I can make the field either Text or Numeric. Any and all suggestions would be greatly appreciated. Thanks and Happy New Year to everyone!

Reply | Quote

Replies

If you make the field into a numeric field, only the numeric value will be stored, not the leading zeros entered by the user. An additional advantage of using a text field is that non-numeric values won’t be accepted by Access.

If you prefer a text field, you could use Val([FieldName]) to get the numeric value. To ensure numeric data entry, you can set the Format property to a built-in or custom numeric format.

Reply | Quote