[sub].Visible = [sub].Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie Isaacs - 14 Dec 2005 10:21 GMT

Hello All

I have a report that includes the yes/no field [sub] in the detail
section.
I would like this field only to be visible when its value is "True". I
thought I could do this very neatly by adding:

[sub].Visible = [sub].Value

to the report's OnOpen event, but this doesn't work - I get:
Runtime Error 2427 You entered an expression that has no value.

I can't understand this - surely both sides of the "=" are booleans and I
should be able to set one from the other?
This is probably laughable to most of you, but I would be grateful if
someone could explain why my expression doesn't work.

Many thanks
Leslie Isaacs

----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 15 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!

Reply to this Message

Allen Browne - 14 Dec 2005 11:42 GMT

Move your code into the Format event of the Detail section.

If the goal is to end up with a checked box for Yes and just white space for
No, you could also use this trick:
Check boxes on reports: change the size, color, unbox them,
and use conditional formatting
at:
http://allenbrowne.com/ser-52.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello All
>
[quoted text clipped - 15 lines]
> Many thanks
> Leslie Isaacs

Reply to this Message