CODEWITHSUNDEEP
ms-access
Steven Bitaxi
Steven Bitaxi

Reputation: 166

Text field format property - Phone number with extension: Populates right to left instead of left to right

Using MSAccess 2016 64 bit with a SQL Server Express back end. I'm trying to store unformatted phone numbers in an nvarchar field.

Stored Value

123456789054321

Expected display format

123-456-7890 x.54321

In order to do so I need to ensure they display correctly on forms and reports.

For some reason, the format property populates from the right to the left. When I type:

1234567890

It displays

 - 1-2345 x.67890

While I expect

123-456-7890 x.

These are the formats I have tried:

&&&\-&&&\-&&&&" x."&&&&&;"(123-456-7890 x.12345)"

@@@\-@@@\-@@@@" x."&&&&&;"(123-456-7890 x.12345)"

What do I need to do to get it to display properly?

Upvotes: 0

Views: 397

Answers (1)

Gustav
Gustav

Reputation: 55841

Put a bang in front:

!@@@\-@@@\-@@@@" x."&&&&&;"(123-456-7890 x.12345)"

The format may need adjustment though after this.

Upvotes: 1

Related Questions