422,764 Members | 1,289 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,764 IT Pros & Developers. It's quick & easy.

To hide the text box when the field is zero

P: 1
Dear all

I have read some of the post but as i am too new to Access

i do not understand such as (Not IsNull(Me.Control))

I have a table to keep all user request on purchase they only have to put "1"if they want and "0" if not

i have that collected and new to run a summary report on what they have selected in order to collect money from them

There is around 20 items. I have made a Query with condition, item > 0 , then i use that for report

Created a report but i just want to display all they have selected not all items
I use Can Shrink for the unbound box but for the text box, can not skip

How can i do that ?

Oct 8 '17 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 30,743
You would make the Record Source of the query to be filtered such that only those records with a value greater than zero are included.
Oct 12 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.