If Statement in report

Dave Elliott

Guest

Posts: n/a

18th Aug 2005

I just need if ([Additional Sample]) value is less than 1 (zero) then
next code following to run
right now the Additional Sample control shows by default 0 and default value
is set to true

If IsNull([Additional Sample]) Then ' less than 1 or equals zero
[Sample #1 Date].Visible = False
[Label100].Visible = False
End If

« Invalid use of Null" (INSERT statement); can I bypass via "IF | Cycle Records »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cbo to pass report criteria variable to report, need help on IF statement	Kovax	Microsoft Access Reports	0	10th Mar 2006 11:23 PM
vba: How do I write a "For Each Statement" nested in a "With Statement"?	Mcasteel	Microsoft Excel Programming	1	8th Nov 2004 10:47 PM
vba: How do I write a "For Each Statement" nested in a "With Statement"?	Mcasteel	Microsoft Excel Programming	1	8th Nov 2004 10:23 PM
vba: How do I write a "For Each Statement" nested in a "With Statement"?	Mcasteel	Microsoft Excel Programming	0	8th Nov 2004 10:08 PM
vba: How do I write a "For Each Statement" nested in a "With Statement"?	Mcasteel	Microsoft Excel Programming	0	8th Nov 2004 09:58 PM