visible label based on text value

I am using a database on a LAN and I have the following in the on format event
Me.ContactList.Visible = Not IsNull(Me.ContactList)
However when one user opens the data base the label is hidden if the
condition is true but if another user on the LAN subsequently accesses the
data base all the labels are displayed
any suggestions
--
thanks as always for the help
jer

jer wrote:

I am using a database on a LAN and I have the following in the on format event
Me.ContactList.Visible = Not IsNull(Me.ContactList)
However when one user opens the data base the label is hidden if the
condition is true but if another user on the LAN subsequently accesses the
data base all the labels are displayed


The only thing I can think of is to verify that the control
value is really Null. Maybe it's a zero length string? or
maybe it's one or more spaces.

If that's what's happening, you should think about why you
set the table field's AllowZeroLength property to Yes. If
it were set to No, it would be Null instead.

If you can not prevent the field from containing a ZLS, try
checking for both Null and ZLS:

Me.ContactList.Visible = (Len(Nz(Me.ContactList, "")) 0)

If the value somehow got set to one or more spaces, then use
the Trim function to get rid of them:

Me.ContactList.Visible = (Len(Trin(Nz(Me.ContactList, "")))
0)

--
Marsh
MVP [MS Access]

Thank you Marshall for the quick response. On closer review I am noticing
something else which is not consistent I supplied one of a number of labels
which are in a group header. In order to format the report to fit on a letter
size page, I have three rows of headers and 3 rows of details, e.g.,
Header= Type

Type1
label1 label2 label3
label4 label 6

detail1 detail2 detail3
detail4 detail6

Type2
label1 label2 label3
label5

detail1 detail2 detail3
detail5

I notice that the labels are not always matching the details. e.g label 5
for type2 is not visible even though there are details under this header
any other suggestions





--
thanks as always for the help
jer

"Marshall Barton" wrote:

jer wrote:

I am using a database on a LAN and I have the following in the on format event
Me.ContactList.Visible = Not IsNull(Me.ContactList)
However when one user opens the data base the label is hidden if the
condition is true but if another user on the LAN subsequently accesses the
data base all the labels are displayed


The only thing I can think of is to verify that the control
value is really Null. Maybe it's a zero length string? or
maybe it's one or more spaces.

If that's what's happening, you should think about why you
set the table field's AllowZeroLength property to Yes. If
it were set to No, it would be Null instead.

If you can not prevent the field from containing a ZLS, try
checking for both Null and ZLS:

Me.ContactList.Visible = (Len(Nz(Me.ContactList, "")) 0)

If the value somehow got set to one or more spaces, then use
the Trim function to get rid of them:

Me.ContactList.Visible = (Len(Trin(Nz(Me.ContactList, "")))
0)

--
Marsh
MVP [MS Access]
.

jer wrote:
Thank you Marshall for the quick response. On closer review I am noticing
something else which is not consistent I supplied one of a number of labels
which are in a group header. In order to format the report to fit on a letter
size page, I have three rows of headers and 3 rows of details, e.g.,
Header= Type

Type1
label1 label2 label3
label4 label 6

detail1 detail2 detail3
detail4 detail6

Type2
label1 label2 label3
label5

detail1 detail2 detail3
detail5

I notice that the labels are not always matching the details. e.g label 5
for type2 is not visible even though there are details under this header
any other suggestions


I'd be willing to bet that what you are seeing is
consistent. It's just not meeting your expectations and we
have yet to figured out why.

OTOH, your statements in this post do seem incinsistent to
me. You said you have 3 rows of headers and 3 rows of
details, but your example has two rows with 3 columns. How
are you doing that? Is the report set up to use 3 columns?
If it's not using 3 columns, how are the details arranged to
get 3 details per row?

Is it true that each type grouping only has one detail
record?

Did you verify that no record has a ZLS or spaces in the
field?

Aother stray thought. Verify that your code is in the
detail section's Format event.

--
Marsh
MVP [MS Access]