By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,622 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

subreport control reference problem

P: n/a


I am trying to manipulate a textbox display value of subreport from main
report's detail print() event.
The goal is this, if there is no record from database, replace the blank
space from textbox with message " No record found ".

I found the exact expression to reference my subreport textbox value
from main report, but when I tried to use IsNull() and Nz() function to
distinguish between blank and non-blank value, surprising it did not
work.

When there is no record in sub-report, the textbox's value is " /<you
entered an expression that has no value/> " in the watch window in debug
mode. I could not find a way around this.

Any expert?

Sincerely

Feng

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The value in the TextBox may really be an empty string. Try:

If Len(Trim$(Me!subReport!TextBox)) = 0 Then
... whatever you do
End IF

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlw/rIechKqOuFEgEQIzjgCfcRHO+T37tbIWyPXSQ7rX8B8lu3cAn1 O8
4uGugakZAw5kv5sueL1XkmxR
=lWmr
-----END PGP SIGNATURE-----
Frank wrote:

I am trying to manipulate a textbox display value of subreport from main
report's detail print() event.
The goal is this, if there is no record from database, replace the blank
space from textbox with message " No record found ".

I found the exact expression to reference my subreport textbox value
from main report, but when I tried to use IsNull() and Nz() function to
distinguish between blank and non-blank value, surprising it did not
work.

When there is no record in sub-report, the textbox's value is " /<you
entered an expression that has no value/> " in the watch window in debug
mode. I could not find a way around this.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.