Textbox not display

  • Thread starter Thread starter TQ
  • Start date Start date
T

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!
 
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.
 
Where do I put this code? Sorry, I'm new to this. Thanks, Karl!

KARL DEWEY said:
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


TQ said:
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!
Click to expand...
Click to expand...
 
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


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

KARL DEWEY said:
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


TQ said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top