list box date column, number column formating

[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

 

[Guest]

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

 

[Guest]

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

You might need to use mm/dd/yy