Combo box displays number in wrong format

[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.

 

[foo]

How are you loading the combo box? Can you provide the SQL statement?

 

[sstrauss]

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

 

[Adrian Jansen]

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

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.