Formatting a Field in a Value List or Combo Box

[David M.]

I have been using Access for about 6 years and have what I
would call 'intermediate' programming skills. That being
said, I am running into a problem which I cannot figure
out how to solve.

When I create a value list or combo box in which contains
more that one field in the row source and one of the row
sources is a number, I cannot format the number field to
not contain decimals and commas. For example, if I have
an Autonumber field which has a value of 13467, on the
value list, it displays as 13,467.00. I have built a
separate query to feed the value list or combo box (I have
also used just an SQL statement to no avail) and the query
or SQL statement displays correctly, but when I run the
form, it ignores the formatting and displays the value
with commas and 2 decimals.

I would appreciate any help in getting this resolved.

Thanks in advance for your time.

 

[Kelvin Lu]

Does the formatting show up in the list or in the combo box after you select
something from the list. If it is in the list, I'm not sure why it does
that. But if it shows up in the box after a selection that sounds like you
have the formatting of the box set to standard. Check the properties of
your combo box and remove any formatting you might have.

Kelvin Lu

 

[David M.]

It shows up on the combo box when you click the box to
drop the list down. It shows on the value list as it
displays in the form.

Does this help any?