value from a text box....

[MikeDNova]

this is probably an easy one. i have a subreport within a report. the subreport contains a text box. now i'm trying to test to see weather or not the text box contains any text in it in VB underlying the main report.


any suggestions???

Thanks in advance!
mike

 

[MikeDNova]

anyone?

 

[Moogle]

You could Try

me.<subreportname>.<fieldname>.value

I can't test it at the moment though.

--
Moogle

 

[MikeDNova]

it seems every different way i try to write it, it keeps giving me this error:

runtime error 2427, you entered an expression that has no value

most of the time this field is going to be empty, and i'm trying to test it to know whether or not its empty. would an empty text box return a &quot;&quot; or a null??? or maybe this just isn't going to work at all.

still taking suggestions please!!
thanks in advance!
-mike
mikednova@hotmail.com

 

[MikeDNova]

i got it
Dim text As String
text = Me.rptInspectionPrintComments.Report.txtInspectionComments.text

what a pain it was to get that to work.