microsoft.public.access

try

cancel = isnull([tblgoalbyequipment].[UOM])

Pieter

"PPCO" wrote in message
news:FA7ECE70-030D-4785-9975-4FDF9649DE6E@microsoft.com...
> 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!