microsoft.public.access
back to index
Group: microsoft.public.access
From: =?Utf-8?B?UFBDTw==?=
Date: Thursday, October 18, 2007 2:19 PM
Subject: Remove Blank Fields in Report
From: =?Utf-8?B?UFBDTw==?=
Date: Thursday, October 18, 2007 2:19 PM
Subject: Remove Blank Fields in Report
I'm trying to remove a blank field in my report through visual basic but it's
giving me a syntax error--I'm new to Access so i'm probably missing something
simple. Here's my code:
Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
IIf([tblgoalbyequipment].[UOM] Is Null, Visible=False, Visible=True)
End Sub
Thanks!
