First off it doesn't matter what the format is on the
backend other than knowing 'what it is' so you can
manipulate it on the front end.
As a suggestion on the backend either store the phone
numbers as a Long or as a String and only store the
numbers because this will facilitate the formatting on
the front end.
On the frontend use the
Format(NumVariable, "(###) ###-#####)") if stored
as a long
or Format(CLng(NumVariable), "(###) ###-####") if
stored as a string
As for exact syntax between the quotes I am not 100%
sure on this since I don't have VB in front of me
right at this moment to verify its usage but it will
be something like that.
Or perhaps VBA has a some kind of default format for
phone numbers that you could use --- check with others
here to verify that part or look it up in the help
section of Access.
Hope that helps.
--- kabtn <[EMAIL PROTECTED]> wrote:
> I have an Access Front End and an SQL back end. I
can't seem
> to get the phone numbers to format correctly.
>
> Not sure what format the numbers should be in the
back end or
> how to get them to come up in the front end.
>
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
