view format problem

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
 
J

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top