date Formatting

[yessir]

I have a form which won't format the date properly in 2 parts.

1) the dropdown, the date won't format as "mmm-yy" when it drops down.

2) the date won't format for when I append it to the RE section.

I have included the db

 

[KenHigg]

Format it in the underlying query for the rowsource.

???
ken

 

[yessir]

i tried that

dl the db and try it

 

[KenHigg]

Try doing a rowsource with 2 cols.

???
ken

 

[yessir]

no...

the problem is that it won't select distinct dates based on month and year

and display them that way

I tried this;
strDate = Format$(Me.cboMonth, "mmm-yy")

but it throws an error.

 

[KenHigg]

Sorry that we seem to be going a cirle here. Is the main problem at this point that you want the message in txtRe. If so, dim strDate as a string.

???
ken