I am using data report with ms access database. I want to the rptTextbox color to change based on the value of the the recordset field. Eg to appear red if the field is "FAIL" and black if it is "PASS". My code is
cmdShowReport_C lick
' '''''''the STATUS field is bound to Text1. """"" rs is recordset
If rs.Fields("STAT US") < 40 THEN
DataReport1.Sec tions(Section1) .Controls("Text 1")...
Fidell
Last Activity: Dec 8 '08, 02:26 PM
Joined: Aug 23 '07
Location:
-
change data report textbox forecolor
-
change data report textbox forecolor
I am using data report with ms access database. I want to the rptTextbox color to change based on the value of the the recordset field. Eg to appear red if the field is "FAIL" and black if it "PASS". My code is
cmdShowReport_C lick
' '''''''the STATUS field is bound to Text1. """"" rs is recordset
If rs.Fields("STAT US") < 40 THEN
DataReport1.Sec tions(Section1) .Controls("Text 1")... -
Query Excel
Please how do query(select some fields) in excel worksheet to display in a grid and textboxes in vb form? How do i avoid the error "invalid use of null" since some of the fields will be blank before values are entered through the textbox?
No activity results to display