This is Access 2000. I have a Combo Box control with a select statement in the row source property specifying the contents of the drop down box and the sort order. The lookup is being pulled from a query which is based on one table. In the dropdown box lookup, one of the columns is appearing with 2 decimals after the number. The table field on which this column of data is based is actually 6 decimal fixed double format. Is there a way to specifiy the settings for the dropdown box lookup so that no decimals will appear in this column, so that each of the numbers will simply be a non decimal whole number? Thanks for any help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box Settings
- Thread starter random75
- Start date
ProgramError
Programmer
Take a look at the format property or the ABS() function
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
- Status
Similar threads
- Locked
- Question