I do believe that Can Grow only works vertically.
--
Build a little, test a little.


"jmoore" wrote:

I can't believe it was so simple. I'm sure I tried to increase the text box
at one time and it did not work. I have the Can Grow set to Yes. Why didn't
that allow the text box to expand when needed?

"KARL DEWEY" wrote:

Increase the horizontal width of the display box.
--
Build a little, test a little.


"jmoore" wrote:

Wish I could do a "Reply to all" for such great response and tips. I
realized after trying the suggestions that I needed to write this as equals
not null. The code below displays the correct information when the two
fields match. However, when they do not, all that displays is a series of
pound signs (########). No text displays at all.

=IIf([EndDate]=[BeginDate],"Review Completed on: " & [BeginDate],"Review
Completed From " & [BeginDate] & " to " & [EndDate])

Thanks.

"KARL DEWEY" wrote:

Try this --
=IIf([EndDate] Is Null, "Review Completed on: " & [BeginDate], "Review
Completed From " & [BeginDate] & " to " & [EndDate])

--
Build a little, test a little.


"jmoore" wrote:

I would like one of two different statements to display on a report based on
whether one field is null. The two fields are BeginDate and EndDate. If
EndDate is null, it should read "Review Completed on: [BeginDate]. If not
null, it should read "Review Completed From [BeginDate] to [EndDate]. I
tried the IIf statement below, but it did not work.

=IIf([EndDate] Is Null,"(“Review Completed on: “ [BeginDate])",(“Review
Completed From “ & [BeginDate] & "to " & [EndDate]))

Thanks.