Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI There. I have set up a query which pulls through to a label report.. but
just wondering how to pull through the formatting. ie. in the forms/tables,
the phone number shows as (02) 6056 0457, but when it pulls through to the
report it is showing as 0260560457 which makes it a little more difficult to
read. Thanks
 
HI There. I have set up a query which pulls through to a label report.. but
just wondering how to pull through the formatting. ie. in the forms/tables,
the phone number shows as (02) 6056 0457, but when it pulls through to the
report it is showing as 0260560457 which makes it a little more difficult to
read. Thanks
Click to expand...

What you are seeing in the table and form is the formatting of the
Phone field, not how it is actually stored.
Change the control source of the Phone control in the report from
[Phone] to
=Format([Phone],"(@@) @@@@ @@@@")
Then make sure the name of this control is not "Phone".
 
Back
Top