view format problem

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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
 
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
Click to expand...

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
 
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
Click to expand...

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