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?

 

[bhicks11 via AccessMonster.com]

Hi News Boy,

I can't seem to duplicate what you are seeing. If it's a long integer field
it should default to no decimals. Maybe something is formatted somewhere
that you aren't seeing. Check in the format properties for the combobox. If
you don't see anything, try setting the format property to fixed and the
decimal places to zero.

Bonnie
http://www.dataplus-svc.com

 

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

 

[bhicks11 via AccessMonster.com]

Of course - much more concise!

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

 

[bhicks11 via AccessMonster.com]

Hi News Boy,

Can I recommend you take a breath, sit through some of these free online
tutorials that Microsoft has out there.

This one is about Queries:

http://office.microsoft.com/training/training.aspx?AssetID=RC010776611033

They have lots of them. You will just continue to be frustrated until you
step back and go through the basics. If you slow down and take it step by
step, you'll become a wiz!

Don't get discouraged.

Bonnie
http://www.dataplus-svc.com

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
[quoted text clipped - 4 lines]

like:
Format(thefield, "0.")

 

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