Solved: Access: Number formatting in combo boxes

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

FarmerGuy

Thread Starter
Joined
Nov 23, 2011
Messages
13
Hi,

I'm using Access 2010 and struggling to get the numbers in a combo box to display in the right format:
The source table holds a series of numbers (years) in the Double, fixed, 0 decimal places format and displays them correctly, 2010,2011 etc. When I use this table as the source for a combo box lookup in a form the numbers are also stored correctly but when i click on the combo box to choose a number they are all displayed as 2010.00, 2011.00 etc.

I can't see any way of removing those decimal places in the drop-down list displayed but there must surely be some really easy/obvious thing that I am overlooking - can anyone help? Thanks.

Richard
 

OBP

Joined
Mar 8, 2005
Messages
19,896
I would set the Field type in the table to "Long Integer", which is only whole numbers with no decimal places at all.
 

FarmerGuy

Thread Starter
Joined
Nov 23, 2011
Messages
13
Hi OBP,

Thanks for the suggestion, that alone didn't work (though I am sure was sound advice) but when i changed the Format option from Fixed to General Number the problem was solved :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top