hiding record with macro

[jacob swinney]

i want to hide all empty records in a form of mine I found the following code but cant get it to work basically because i have to have a space inbetween the field name

The code i found is as follows:

Private Sub Form_Current()
If Not Me.NewRecord Then
If IsNull(Me!ContractDate) Then
Me!ContractDate.Visible = False
Me!LabelName.Visible = False
Else
Me!ContractDate.Visible = True
Me!LabelName.Visible = True
End If
Else
Me!ContractDate.Visible = True
Me!LabelName.Visible = True
End If
End Sub


My Field Name is "AFRICAN SUMAC" to replace "ContractDate"

It comes back as a List Separator and End Code Error message


Any help on how i can substitue for a space _ in the so i can use "AFRICAN SUMAC" in the macro without removing the space in the field name

[TheSmileyCoder]

Hi and welcome to BYTES
Access has a different naming convention for macros then Excel does. When you write code like that, its usually referred to as Visual Basic Code and not a macro.

If you want to use form names/control names where you have a space, you can use [] around the name:

Me![AFRICAN SUMAC].Visible = True 

I might add that I ALWAYS when making tables use underscores when creating field names (and table/query/form/report names) for example AFRICAN_SUMAC.