deanvilar Registered User. Local time Today, 01:16 Joined Mar 27, 2013 Messages 63 May 1, 2013 #1 Help Guys .... I need to hide a row in my report for example (in Detail Format event of the report): If me.txtReleased = "YES" then hide row endif thanks in advance.
Help Guys .... I need to hide a row in my report for example (in Detail Format event of the report): If me.txtReleased = "YES" then hide row endif thanks in advance.
C CJ_London Super Moderator Staff member Local time Today, 09:16 Joined Feb 19, 2013 Messages 17,756 May 1, 2013 #2 I would modify your source query to exclude records where txtReleased = "YES"
deanvilar Registered User. Local time Today, 01:16 Joined Mar 27, 2013 Messages 63 May 1, 2013 #3 I did ... but the problem is that the query comes first to display the data and it cant fetch the value YES or NO generated from detail format event of the report.
I did ... but the problem is that the query comes first to display the data and it cant fetch the value YES or NO generated from detail format event of the report.
deanvilar Registered User. Local time Today, 01:16 Joined Mar 27, 2013 Messages 63 May 1, 2013 #4 I found it!!!! if me.released = "YES" then Cancel = True end if
C CJ_London Super Moderator Staff member Local time Today, 09:16 Joined Feb 19, 2013 Messages 17,756 May 1, 2013 #5 Excellent - you could rewrite as Cancel=me.released = "YES"
