T
terryh70
I am using the following syntax in an unbound control on a form.
=[sub148331st] & ((Chr(13) & Chr(10)) & ([sub248331st])) & ((Chr(13) &
Chr(10)) & ([sub348331st])) & ((Chr(13) & Chr(10)) & ([sub448331st])) &
((Chr(13) & Chr(10)) & ([sub548331st]))
All Fields are Date Fields, with medium date format.
The dates show up in the format of 4/17/2006 and the field does not shrink,
it still shows blanks space where the date value is null, making the report
gbeing to large and each entry too far apart.
Q: How do I get the dates to show on the report in the medium date format
and how do i get the blanks spaces to go away.
The control and the detail section are set to can grow and can shrink. the
same format works for my other fields, just not the fields containing dates.
=[sub148331st] & ((Chr(13) & Chr(10)) & ([sub248331st])) & ((Chr(13) &
Chr(10)) & ([sub348331st])) & ((Chr(13) & Chr(10)) & ([sub448331st])) &
((Chr(13) & Chr(10)) & ([sub548331st]))
All Fields are Date Fields, with medium date format.
The dates show up in the format of 4/17/2006 and the field does not shrink,
it still shows blanks space where the date value is null, making the report
gbeing to large and each entry too far apart.
Q: How do I get the dates to show on the report in the medium date format
and how do i get the blanks spaces to go away.
The control and the detail section are set to can grow and can shrink. the
same format works for my other fields, just not the fields containing dates.