Can Grow Can shrink and Dates

[Guest]

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.

 

[Allen Browne]

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination of
the different concatenation operators (+ and &) should take care of the line
shrinking.

 

[Guest]

The Format() worked great, and each entry is on a new line, also great, but
still does not shrink.

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination of
the different concatenation operators (+ and &) should take care of the line
shrinking.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

 

[Allen Browne]

More detail please.

If sub348331st is null, do you see a blank line between sub248331st and
sub448331st? Or are you saying the spacing is correct in this field, but
ther lower controls do not move up the report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The Format() worked great, and each entry is on a new line, also great,
but
still does not shrink.

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination of
the different concatenation operators (+ and &) should take care of the
line
shrinking.

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.

 

[John Spencer]

Pardon me,
But I think using format on a Null returns a zero-length string.

?Len(Format(Null,"Medium Date")) Returns zero
?Len(Null) returns Null

Which means you need to add a test for that

=IIF([sub148331st] is Null, Null, Format([sub148331st], "Medium Date")) +
Chr(13) + Chr(10) &
IIF([sub248331st] is ...

More detail please.

If sub348331st is null, do you see a blank line between sub248331st and
sub448331st? Or are you saying the spacing is correct in this field, but
ther lower controls do not move up the report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The Format() worked great, and each entry is on a new line, also great,
but
still does not shrink.

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination
of
the different concatenation operators (+ and &) should take care of the
line
shrinking.


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.

 

[Allen Browne]

Spot on, John. Thanks.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Pardon me,
But I think using format on a Null returns a zero-length string.

?Len(Format(Null,"Medium Date")) Returns zero
?Len(Null) returns Null

Which means you need to add a test for that

=IIF([sub148331st] is Null, Null, Format([sub148331st], "Medium Date")) +
Chr(13) + Chr(10) &
IIF([sub248331st] is ...

More detail please.

If sub348331st is null, do you see a blank line between sub248331st and
sub448331st? Or are you saying the spacing is correct in this field, but
ther lower controls do not move up the report?

The Format() worked great, and each entry is on a new line, also great,
but
still does not shrink.

:

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination
of
the different concatenation operators (+ and &) should take care of the
line
shrinking.


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.

 

[Guest]

Thanks a million to both of you that works awesomely.

Spot on, John. Thanks.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Pardon me,
But I think using format on a Null returns a zero-length string.

?Len(Format(Null,"Medium Date")) Returns zero
?Len(Null) returns Null

Which means you need to add a test for that

=IIF([sub148331st] is Null, Null, Format([sub148331st], "Medium Date")) +
Chr(13) + Chr(10) &
IIF([sub248331st] is ...

More detail please.

If sub348331st is null, do you see a blank line between sub248331st and
sub448331st? Or are you saying the spacing is correct in this field, but
ther lower controls do not move up the report?

The Format() worked great, and each entry is on a new line, also great,
but
still does not shrink.

:

Try:
=Format([sub148331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub248331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub348331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub448331st], "Medium Date") + Chr(13) + Chr(10) &
Format([sub548331st], "Medium Date")

The Format() function shows the dates as requestd, and the combination
of
the different concatenation operators (+ and &) should take care of the
line
shrinking.


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.