"Allan Koch" <al***@koch.dk> wrote in message
news:40***********************@dread16.news.tele.d k...
Hi Fletcher,
Thanks !
Yes I know a record doesn't have a colour.
I used your advise, the only thing is that I am not able to have the hole
line formatted in one solid colour because check box fields do not have
the "conditional format" available. Do you think there is a cure for that ?
( I want it to look like, you have selected the hole record row, just in a
different colour than black)
regards
allan
Hi Allan
If you have your subform in datasheet view, then you probably have the least
flexibility in what it looks like. If you used the continuous forms view
then other possibilities are opened up such as placing shapes or many
transparent textboxes placed on one coloured one. However, on balance, I
still prefer the datasheet view for subforms and I would probably not use a
check box.
I would define a field in my query such as:
IIf([MyField]=1,"X",Null) AS TrueOrFalse
So that I could use a textbox to display an "X" rather than use a checkbox.
Of course, you then have to write code to allow updating. Perhaps someone
else might have an imaginative suggestion and Stephen Lebans is a likely
candidate - you could try his website at
http://www.lebans.com/
Fletcher