I want this text box not to show this unless tbDirectBank has data in it!
=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
fredg said:I want this text box not to show this unless tbDirectBank has data in it!=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
What is 'tbDirectBank'? Is it a field in the form's record source?
What is the datatype of [OwnerID]? I suspect it's a Number datatype, not
text.
You wish to show just the first 3 characters of [OwnerLastName] in Upper
Case.
Is this all correct?
=IIf(IsNull([tbDirectBank]),"",UCase(Left(DLookUp("[OwnerLastName]",
"tblOwnerInfo","[OwnerID] = " & [tbOwnerID]),3)))
Bob said:Brilliant Fred your a mind reader too. Worked perfectly. Just did not want
to show Direct Banking details if there was no Bank listed in
tbDirectBanking
So with any other text boxes relevant I just have to add ,
IIf(IsNull([tbDirectBank]),"", to the start and and ) at the finish?
fredg said:I want this text box not to show this unless tbDirectBank has data in
it!=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
What is 'tbDirectBank'? Is it a field in the form's record source?
What is the datatype of [OwnerID]? I suspect it's a Number datatype, not
text.
You wish to show just the first 3 characters of [OwnerLastName] in Upper
Case.
Is this all correct?
=IIf(IsNull([tbDirectBank]),"",UCase(Left(DLookUp("[OwnerLastName]",
"tblOwnerInfo","[OwnerID] = " & [tbOwnerID]),3)))
How would you get a label (label87)to show blank in the same
instance...............Regards Bob
Bob said:Brilliant Fred your a mind reader too. Worked perfectly. Just did not want
to show Direct Banking details if there was no Bank listed in
tbDirectBanking
So with any other text boxes relevant I just have to add ,
IIf(IsNull([tbDirectBank]),"", to the start and and ) at the finish?
fredg said:On Wed, 6 Dec 2006 11:13:26 +1300, Bob wrote:
I want this text box not to show this unless tbDirectBank has data in
it!
=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
What is 'tbDirectBank'? Is it a field in the form's record source?
What is the datatype of [OwnerID]? I suspect it's a Number datatype, not
text.
You wish to show just the first 3 characters of [OwnerLastName] in Upper
Case.
Is this all correct?
=IIf(IsNull([tbDirectBank]),"",UCase(Left(DLookUp("[OwnerLastName]",
"tblOwnerInfo","[OwnerID] = " & [tbOwnerID]),3)))
I'm not at all sure of what you are attempting to do here, but in a
report you can code the Detail Format event:
Me![Label87].Caption = IIf(IsNull(etc......)
In a Form, you would use the Form's Current event.
fredg said:How would you get a label (label87)to show blank in the same
instance...............Regards Bob
Bob said:Brilliant Fred your a mind reader too. Worked perfectly. Just did not
want
to show Direct Banking details if there was no Bank listed in
tbDirectBanking
So with any other text boxes relevant I just have to add ,
IIf(IsNull([tbDirectBank]),"", to the start and and ) at the finish?
On Wed, 6 Dec 2006 11:13:26 +1300, Bob wrote:
I want this text box not to show this unless tbDirectBank has data in
it!
=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = "
&
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
What is 'tbDirectBank'? Is it a field in the form's record source?
What is the datatype of [OwnerID]? I suspect it's a Number datatype,
not
text.
You wish to show just the first 3 characters of [OwnerLastName] in
Upper
Case.
Is this all correct?
=IIf(IsNull([tbDirectBank]),"",UCase(Left(DLookUp("[OwnerLastName]",
"tblOwnerInfo","[OwnerID] = " & [tbOwnerID]),3)))
I'm not at all sure of what you are attempting to do here, but in a
report you can code the Detail Format event:
Me![Label87].Caption = IIf(IsNull(etc......)
In a Form, you would use the Form's Current event.
fredg said:How would you get a label (label87)to show blank in the same
instance...............Regards Bob
Bob said:Brilliant Fred your a mind reader too. Worked perfectly. Just did not
want
to show Direct Banking details if there was no Bank listed in
tbDirectBanking
So with any other text boxes relevant I just have to add ,
IIf(IsNull([tbDirectBank]),"", to the start and and ) at the finish?
On Wed, 6 Dec 2006 11:13:26 +1300, Bob wrote:
I want this text box not to show this unless tbDirectBank has data in
it!
=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = "
&
[tbOwnerID] & ""),""),3)) if tbDirectBank is Null show ""+
What is 'tbDirectBank'? Is it a field in the form's record source?
What is the datatype of [OwnerID]? I suspect it's a Number datatype,
not
text.
You wish to show just the first 3 characters of [OwnerLastName] in
Upper
Case.
Is this all correct?
=IIf(IsNull([tbDirectBank]),"",UCase(Left(DLookUp("[OwnerLastName]",
"tblOwnerInfo","[OwnerID] = " & [tbOwnerID]),3)))
I'm not at all sure of what you are attempting to do here, but in a
report you can code the Detail Format event:
Me![Label87].Caption = IIf(IsNull(etc......)
In a Form, you would use the Form's Current event.
I'm not at all sure of what you are attempting to do here, but in a
report you can code the Detail Format event:
Me![Label87].Caption = IIf(IsNull(etc......)
In a Form, you would use the Form's Current event.
Fred where do I find the: Detail Format event
I cant seem to find it!
Thanks.......Bob
Even if the label and text box are in the page footer section of the report?fredg said:On Thu, 7 Dec 2006 09:33:02 +1300, Bob wrote:
** snipped **I'm not at all sure of what you are attempting to do here, but in a
report you can code the Detail Format event:
Me![Label87].Caption = IIf(IsNull(etc......)
In a Form, you would use the Form's Current event.
Fred where do I find the: Detail Format event
I cant seem to find it!
Thanks.......Bob
In Report Design View, display the property sheet.
Then click anywhere in a blank area of the detail section.
Click on the property sheet's Event tab.
The Detail Format event is the first event listed.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.