list box date column, number column formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
One more thing, the format I used dd/mm/yyyy
dd - day
mm - month
yy - year

You might need to use mm/dd/yy
 
Back
Top