Convert number

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

Guest

Hi,

Try to format a number field to display in a phone format (999)999-9999 on
report.

=format([field1],"(000)000-0000")

I got #error

=format(CSTR([field1],"(000)000-0000")

I got error 0

What am I missing? Any insights will be greatly appreciated.

Thanks,
Siew-Ming
 
Hi,

For the text box properties that you have the phone displayed on the
report. Try the following:

Under Data tab:
Control Source ........: [Field1]

Under Format tab:
Format........: (000) 000-0000

Cheers!
-Lem
 
Hi,

Try to format a number field to display in a phone format (999)999-9999 on
report.
Click to expand...

A phone number should be stored in a Text field. You'll never be doing
arithmatic with it after all! Number... Long Integer fields are
limited to values under 2147483647 so if you ever need to use
international dialing codes, you'll be in trouble!
=format([field1],"(000)000-0000")
Click to expand...

Just set the Input Mask property of the field to

(000)000-0000

or set the Format property of the form/report control to the same.

John W. Vinson[MVP]
 
Back
Top