What's a E+04?!?!

[Guest]

Okay, I have a table. It has many fields, including EmployeeID, Department,
etc.

I made a form that I call my "View History." On it are two things: a text
box in which you enter the EmpID number, and an "OK" button. You punch in
the dude's # and click OK and BOOM, it opens a report based on a query based
on the table and tells me everything I've charged dude with. The purpose of
this is to verify if an employee has already been charged with something,
because if not, dude's gotta pay, comprende? NO PROBLEMS TO THIS POINT.

I make a second form, exactly like the first except it has a combo instead
of a text box. The field values for this combo are "Charged, Exempt,
ToBePaid". The purpose of this form is so that I can see who all is exempt
(based on one of those above 3 values in the "Exemption Status" field). Now,
that's not a problem. It pulls up all my data just fine and dandy---except
where it should have their employee ID listed, it says E+04 for EVERY
employee record. Let's say I click on the combo box, and click on "ToBePaid"
because I want to run a report (still based on a query based on the table) of
who all owes me money. EVERYTHING on both these forms works JUST fine,
except in this second form it won't show their EmployeeID numbers, just that
E+04 thingy.

Now, this form is EXACTLY like the previous; the macro, query, report and
table are almost identical; I just changed out the necessary info needed to
make it pull up the right data.

So why do I get the E+04 thing?

 

[Sylvain Lafontaine]

This is scientific notation and it's used when you choose it as the display
format or when the field is to short to display the full number.

In you case, using a greater field length is probably the solution.

 

[Guest]

oh my stars and garters...i've wasted three hours and i could have simply
drug the box shape a bit bigger. ha. ha ha. that figures.

Thank you infinitely sylvain, that solved my problem! I would have wasted
another 3 hrs before i tried that. Thanks!

 

[John Vinson]

Now, this form is EXACTLY like the previous; the macro, query, report and
table are almost identical; I just changed out the necessary info needed to
make it pull up the right data.

So why do I get the E+04 thing?

Either that text box is a bit smaller, or it's using a larger font.

If a Number field is too large to display in a textbox, Access
switches to scientific notation - i.e. the number 51234 can also be
displayed as 5.1234E+04. In a (perhaps misguided) attempt to provide
at least *some* information, Access switches to a truncated scientific
notation to at least give you the order of magnitude of the number.

Try making the textbox a couple of twenty-fourths of an inch
(gridlines) bigger.

John W. Vinson[MVP]