Convert number

[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

 

[lgalumbres]

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

 

[John Vinson]

Hi,

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

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")

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]