David8
10-04-2010, 01:17 PM
As per title. This does not seem to be possible, unless Display Control can be called in SQL code? I doubt it, but maybe.
This really annoys me. I want a check box to come up for my CALCULATED FIELD in my Table, and especially in my Query. Yes my caculated field will deliver True or False.
There's nothing like a ticked box to jump out at you. Much better than a solid block of Yes/No.
boblarson
10-04-2010, 01:45 PM
FORMS are where you can control this. Trying to work in tables or queries - they just aren't set up to be as flexible.
vbaInet
10-04-2010, 01:49 PM
You seem to be the only one not so happy about this ;)
Sadly you can't get a control displayed for a calculated field. However, you can do it on a form and set it to open in Datasheet view. That way it looks like query plus you get the check box.
David8
10-04-2010, 11:00 PM
You seem to be the only one not so happy about this ;)
Sadly you can't get a control displayed for a calculated field. However, you can do it on a form and set it to open in Datasheet view. That way it looks like query plus you get the check box.
A form that looks like a query? That sounds very interesting, and as a beginner not something I've seen yet. I shall have to set one of those up and have a play with it.
vbaInet
10-05-2010, 12:38 AM
Good luck in your discovery.
Feel free to ask questions as you go along.