(Msg. 1) Posted: Thu Jul 24, 2008 7:41 am
Post subject: Textbox not display Archived from groups: microsoft>public>access>reports (more info?)
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!
(Msg. 2) Posted: Thu Jul 24, 2008 12:06 pm
Post subject: RE: Textbox not display [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" wrote:
> 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!
(Msg. 3) Posted: Thu Jul 24, 2008 1:31 pm
Post subject: RE: Textbox not display [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Where do I put this code? Sorry, I'm new to this. Thanks, Karl!
"KARL DEWEY" wrote:
> 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" wrote:
>
> > 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!
(Msg. 4) Posted: Thu Jul 24, 2008 2:10 pm
Post subject: RE: Textbox not display [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" wrote:
> Where do I put this code? Sorry, I'm new to this. Thanks, Karl!
>
> "KARL DEWEY" wrote:
>
> > 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" wrote:
> >
> > > 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!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other