Textbox not display

[TQ]

My "Comment" textbox is place at the end of a page; a page break is placed
after it. Somehow when the a record does not have comment, the "Comment"
textbox is not displayed. How can I make it appear regardless it is filled
with text or is empty. Thanks!

 

[KARL DEWEY]

Try using an IIF statement --
Expr1: IIF([TextBox] Is Null, Chr(13) & Chr(10), [TextBox])

You can add more Chr(13) & Chr(10) based on how many line spaces you want.

 

[TQ]

Where do I put this code? Sorry, I'm new to this. Thanks, Karl!

Try using an IIF statement --
Expr1: IIF([TextBox] Is Null, Chr(13) & Chr(10), [TextBox])

You can add more Chr(13) & Chr(10) based on how many line spaces you want.
--
KARL DEWEY
Build a little - Test a little

My "Comment" textbox is place at the end of a page; a page break is placed
after it. Somehow when the a record does not have comment, the "Comment"
textbox is not displayed. How can I make it appear regardless it is filled
with text or is empty. Thanks!

 

[KARL DEWEY]

Put it in your query used to feed the report. It will be a calculated field.

You will need to edit your report to use the aliase you assign instead of
Expr1.

--
KARL DEWEY
Build a little - Test a little

Where do I put this code? Sorry, I'm new to this. Thanks, Karl!

Try using an IIF statement --
Expr1: IIF([TextBox] Is Null, Chr(13) & Chr(10), [TextBox])

You can add more Chr(13) & Chr(10) based on how many line spaces you want.
--
KARL DEWEY
Build a little - Test a little

My "Comment" textbox is place at the end of a page; a page break is placed
after it. Somehow when the a record does not have comment, the "Comment"
textbox is not displayed. How can I make it appear regardless it is filled
with text or is empty. Thanks!