Combo box displays number in wrong format

  • Thread starter Thread starter sstrauss
  • Start date Start date
S

sstrauss

I have a combo box in a form that is not displaying
numbers in the correct format. My row source has two
columns--both are long integers. The combo box displays
these numbers with two decimal places.

How/where do I control the format?

Thanks.
 
I am using a SELECT statement from a table.

SELECT tblEmpMstr.eeno, tblEmpMstr.loc, tblEmpMstr.name FROM tblEmpMstr

eeno and loc are both long integers

This a real mystery to me. I have been developing this application for a number of weeks now and for some reason this problem has popped up. I noticed that ALL my combo boxes are now displaying decimal point followed by 2 zeros even though the numbers are long integers

Thanks
 
Check the format property of both the source table field, and the combo box
on the form. One will most likely be set to a decimal display format.

As an aside, I notice you have a field named "name" in your tblEmpMstr
table. "name" is a reserved word in Access, and using it for a field name
will give you problems.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
sstrauss said:
I am using a SELECT statement from a table.

SELECT tblEmpMstr.eeno, tblEmpMstr.loc, tblEmpMstr.name FROM tblEmpMstr;

eeno and loc are both long integers.

This a real mystery to me. I have been developing this application for a
Click to expand...
number of weeks now and for some reason this problem has popped up. I
noticed that ALL my combo boxes are now displaying decimal point followed by
2 zeros even though the numbers are long integers.
 
Back
Top