Numbers over 100 print funny

  • Thread starter Thread starter mabyn
  • Start date Start date
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?
 
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.
 
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
'====================================================
 
Back
Top