list box date column, number column formating

G

George

Hi to all,

Is there a way to

1. format date fields (i.e. 01/01/07 instead of 1/1/07) when they appear on
a list box?

2. format number fields so that no decimal digits show (i.e. 1234 instead of
1234,45) when they appear on a list box?

thanks in advance, George
 
O

Ofer Cohen

You need to change the list box RowSource,and there apply the right format
for each field, using Format for the date and use the Round function for the
number

Select Format([DateField],"dd/mm/yyyy") As NewDateField , Round([MyNumber])
As NewNumber From TableName
 
O

Ofer Cohen

One more thing, the format I used dd/mm/yyyy
dd - day
mm - month
yy - year

You might need to use mm/dd/yy
 
Top