dropdown decimal places

[News Boy]

I have long integers formatted as fixed with zero decimal places. They
appear correctly on the form's control boxes, but on the drop-down list
displays them with two decimal places. How do I get rid of decimal places
displayed on Integers in a control box drop-down?

 

[Marshall Barton]

I have long integers formatted as fixed with zero decimal places. They
appear correctly on the form's control boxes, but on the drop-down list
displays them with two decimal places. How do I get rid of decimal places
displayed on Integers in a control box drop-down?

Change the combo box's RowSource query to use an expression
like:
Format(thefield, "0.")

 

[News Boy]

That sounds like a good idea. But I don't know how to do it, yet. My
rowsource is a table, not a query. I am poking in the dark, unable yet to
write a query from scratch, limited to creating forms and queries in Wizards,
trying to nderstand SQL.

I wouldn't even know what kind of query to create for a RowSource query. I
don't even know how to view the form's source code in Access. And I've got a
much bigger problem you can see if you view my post , "debugging query-forms"
on the previous page.

If you and Bonnie can explain that to me, you're geniuses. Geni-i? Real
smart. Thanks.

- Dixon

 

[News Boy]

well, the Format(thefield,'0.') idea did not work. I get syntax errors, or
missing operator errors, and the Format() function does not appear in my help
files.

So what is the proper syntax to change SELECT Routes.Carrier FROM Routes; to
include Format(Routes.Carrier,'0.') ?

 

[Marshall Barton]

Try it with the quoting that I posted.

If you still can't get it to work, post the SQL statement
that you tried.