Make month list last day

[Guest]

I have a text box that shows the end of the Month. It says "May 2005". I
want a text box to show the last day of the month. How can this be done?

 

[Douglas J. Steele]

How are you getting the existing value? Do you have a field that it's based
on? If you've got a value dtmWhatDate, you can figure out the last day of
that month as DateSerial(Year(dtmWhatDate), Month(dtmWhatDate) + 1, 0)