view format problem

[fishqqq]

I have a filed on a report that i can't seem to format properly.
The field in the form that the user imputs has the following input
mask 999\ 9999\ 9999 which works perfectly.

when this field is viewed on the report the formatting is lost.
Can someone suggest how to get the formatting on the report to show
999 9999 9999 instead of 99999999999?

Thanks
STeve

 

[John W. Vinson]

I have a filed on a report that i can't seem to format properly.
The field in the form that the user imputs has the following input
mask 999\ 9999\ 9999 which works perfectly.

when this field is viewed on the report the formatting is lost.
Can someone suggest how to get the formatting on the report to show
999 9999 9999 instead of 99999999999?

Thanks
STeve

Use a Format property of

"@@@ @@@@ @@@@"

I presume this is a Text field rather than a Number - it's too big for a
number to fit (2^32-1).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[fishqqq]

Use a Format property of

"@@@ @@@@ @@@@"

I presume this is a Text field rather than a Number - it's too big for a
number to fit (2^32-1).
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

You were right it was a text field - guess why my formatting didn't
work eariler
thanks