Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    122

    Unanswered: Format Telepone Number

    I am using a stored procedure to query data in a SQL backend. I have the telephone number stored as 9999999999. I am wondering how I can get that number formatted and displayed in a list box. I want standard formatting, (999) 999-9999. How can I do this? Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    I created a table called tblBackEndPhoneNumber with field PN. Then I created a form with an unbound listbox with RowSourceType = Table/Query and the following as the RowSource:

    SELECT format([PN],"(000) 000-0000") FROM tblBackEndPhoneNumber;

    Seems to work.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Sep 2003
    Posts
    122
    I got it. Thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •