Invisible label when text box empty

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a query which returns dates for 'initiated' new members, but some
members will not have dates in the initiated field.
So when I print the report I would like the date and label to be displayed
if
there is a date in the initated text box, but when there is not a date the
label is not
to be visible.
The format of the initiated text box is set to date format, the label is
labelled
Iniated.
Does this need a macro to make this work?
Jim
 
Try this in the On Format property of the details section
of your report
Me.[Label].Visible = Not IsNull(Me.[Initiated Text Box])

Jim
 
Hi Chris/Jim
The Macro Me won't run, is it correct?
The label is named Initiated, the text box is named Iniated
Jim


Jim/Chris said:
Try this in the On Format property of the details section
of your report
Me.[Label].Visible = Not IsNull(Me.[Initiated Text Box])

Jim
-----Original Message-----
I have a query which returns dates for 'initiated' new members, but some
members will not have dates in the initiated field.
So when I print the report I would like the date and label to be displayed
if
there is a date in the initated text box, but when there is not a date the
label is not
to be visible.
The format of the initiated text box is set to date format, the label is
labelled
Iniated.
Does this need a macro to make this work?
Jim



.
Click to expand...
Click to expand...
 
Windows 2000
Let's start over
You want to hide the label Initiated if the text box is
null. Correct?
Run your report either from a macro or a command button
Open the report in design view
Bring up the properties box
Click in the section of the report that contains the two
fields.
In the On Format property of this section of the report
click on event procedure.
click on the 3 dots ... and you will be brought to the code
window
Insert the following code
Me.[initiated].Visible = Not IsNull(Me.[Iniated])
"Me" refers to the current object(the report)

Jim
-----Original Message-----
Hi Chris/Jim
The Macro Me won't run, is it correct?
The label is named Initiated, the text box is named Iniated
Jim


Try this in the On Format property of the details section
of your report
Me.[Label].Visible = Not IsNull(Me.[Initiated Text Box])

Jim
-----Original Message-----
I have a query which returns dates for 'initiated' new members, but some
members will not have dates in the initiated field.
So when I print the report I would like the date and label to be displayed
if
there is a date in the initated text box, but when there is not a date the
label is not
to be visible.
The format of the initiated text box is set to date format, the label is
labelled
Iniated.
Does this need a macro to make this work?
Jim



.
Click to expand...
Click to expand...


.
Click to expand...
 
Hi Jim
Brilliant, I had called the the label lblInitiated and the text box
txtInitiated
hence the falling over.
Many thanks for your help, very much appreciated
Jim

Jim/Chris said:
Windows 2000
Let's start over
You want to hide the label Initiated if the text box is
null. Correct?
Run your report either from a macro or a command button
Open the report in design view
Bring up the properties box
Click in the section of the report that contains the two
fields.
In the On Format property of this section of the report
click on event procedure.
click on the 3 dots ... and you will be brought to the code
window
Insert the following code
Me.[initiated].Visible = Not IsNull(Me.[Iniated])
"Me" refers to the current object(the report)

Jim
-----Original Message-----
Hi Chris/Jim
The Macro Me won't run, is it correct?
The label is named Initiated, the text box is named Iniated
Jim


Try this in the On Format property of the details section
of your report
Me.[Label].Visible = Not IsNull(Me.[Initiated Text Box])

Jim

-----Original Message-----
I have a query which returns dates for 'initiated' new
members, but some
members will not have dates in the initiated field.
So when I print the report I would like the date and label
to be displayed
if
there is a date in the initated text box, but when there
is not a date the
label is not
to be visible.
The format of the initiated text box is set to date
format, the label is
labelled
Iniated.
Does this need a macro to make this work?
Jim



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top