Numbers over 100 print funny

M

mabyn

I am printing labels that have numbers on them from a table with
"registration numbers". All look okay from 1-99 but numbers over that (100+)
are showing up as +02. How do I get the report to print the correct
registration numbers 100 and above?
 
K

karl dewey

The +02 is scientific notation - the number raised to 2 power of 10 or
multiply by 100.
Open the report in design view and check the format of the object. Set
property to General Number, Fixed, or Standard.
 
J

John Spencer

Also make the control wider so it can display numbers with more than 2
characters.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

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

Similar Threads

Paragraph numbering in Word 1
How can the font and size of (all) citation numbers be altered? 1
Auto numbers over 100 display incorrectly in report 2
Weighted % Complete calculation 1
Mail Merge Help 1
Lost my Table of Contents , Appendices and Page numbers ? 2
Duplicate record 1
Six columns randon no.'s no dupes 6

Top