Use = ("-" + [ipend]) instead. The plus sign will propagate a Null
and if [ipend] is Null then the entire value is Null.
--- In [email protected], "chadcbc" <[EMAIL PROTECTED]> wrote:
>
> I have report which lists ip addresses. If there is a range
instead
> of a single address a field named dash appears after the first with
> the contents:
>
> ="- " & [ipend]
>
> In this situation the dash shows up whether or not there is a value
> for ipend. How can I get this to hide the field if there is no
value
> for ipend?
>
> I have tried If IsNull(Me.IPEnd) Then Me.dash.Visible = False
>
> This somewhat works, if the last record in the ip report has IPEnd
all
> still show the dash, if the lasr record does not have IPEnd all of
> them are hidden. That is not what I want.
>
>
> thanks,
> ~Chad
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
