format / highlight entire row

[Kevin Ensign]

Highlight entire row

New to Access, so still learning how to navigate and terms. This is my first data base I'm attempting to help with.

creating a report and can not get the entire row to highlight. I have attempted different ways and still no luck. In conditional formatting I can get just the cell to highlight yellow using "field value" , but wanting the entire row. Have tried with "expression is" and still no luck. Not sure if I'm using the wrong logic or I have something wrong.

thanks for any suggestions,
Kevin

 

[Kevin Ensign]

New to Access and working with co-worker trying to help me understand how to navigate and create a database.

I have been able to highlight the cell using conditional formatting and "field value" but not the entire row using "expression is". I'm not sure if using the wrong logic or something in my report?

Thanks for any suggestions,
Kevin

 

[CJ_London]

'expression is' is the way to go to conditionally format controls based on values in another control - you say you think you have the wrong logic - what logic are you using?

Note that another option to highlight an entire row is to create an unbound textbox, size it to the width and height of the row and 'send to back' so it is behind all the other controls, then use conditional formatting to format as required. You would also need to ensure that the existing controls backstyle is set to transparent

 

[arnelgp]

you must apply the conditions to all textboxex, comboboxes.

 

[pbaldy]

Re: Highlight entire row

Conditional Formatting would work, using Expression Is for the other controls. Can't say why your attempt didn't work, as you didn't post it.

Something to watch out for is that Access will sometimes put the field name in quotes if you don't add brackets in CF.

[FieldName] = True

 

[pbaldy]

Duplicate threads merged since both had replies (one had been moderated for some reason).

 

[Kevin Ensign]

Lots of questions as I'm learning.
was using [Recovery]="Yes" for my logic
I believe we added an unbound text box called Recoverable, underneath the bound text box.

What do you mean "send back". I couldn't find a good reference to this and how do I check to see if the controls are transparent?

 

[Kevin Ensign]

Thought I would add a screen shot of the property sheet for both bound and unbound text box's to ensure I didn't label anything incorrectly?

 

[Kevin Ensign]

I have done the below as suggested. So now I think I'm using the wrong logic. have used the following:

[Recovery]="Yes"
"Yes"


" create an unbound textbox, size it to the width and height of the row and 'send to back' so it is behind all the other controls, then use conditional formatting to format as required. You would also need to ensure that the existing controls backstyle is set to transparent[/QUOTE]to

 

[CJ_London]

recovery needs to be the name of the control

Alternatively, since it is your formula

Expression is....[Recoverable]=True

 

[Kevin Ensign]

Still did not receive a highlighted row, I have attached two screen shots of both. Just to be clear my control is the text box in the detail section?

Is there any way to confirm the transparency is on?

 

[pbaldy]

Not sure why your posts are being moderated, but I've approved them. CJ, are you using that tapatalk or whatever?

 

[CJ_London]

no - I approved one moderated post - one that you then merged so perhaps it's a glitch.

 

[pbaldy]

There were 4 moderated, post merge.

 

[Kevin Ensign]

guess the confusion goes beyond my lack of knowledge LOL.
Does anyone have more suggestions I could look for to solve this?
Thanks Moderator's for keeping up,
Kevin

 

[Kevin Ensign]

o.k. I've figured out quite a bit trying to make this work today. the propety sheet has the items i needed to change, wasn't familiar with that up to this point. still haven't produced the results, but feel i may be getting closer.
Kevin

 

[CJ_London]

you have your answer in your crosspost here

http://www.accessforums.net/showthread.php?t=61190

suggest you read this thread

http://www.excelguru.ca/content.php?184

 

[pbaldy]

And again, the 2 posts previous to CJ's were moderated.