Ms Access Continuous Form Height Based on Records
Try playing around with Conditional Formatting:
Highlight all the fields in Design view and the choose Format Design Tools, Design, Conditional, from the drop down for condition 1 select Field Has Focus, pick a color.
Experiment. Hope this helps.
If this answer solves your problem, please check, Mark as Answered . If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire
Shane Devenshire
7 people found this reply helpful
·
Was this reply helpful?
An additional point you can Freeze any column you want and it will stay in view in the leftmost position. That is done by right-clicking a field title and choosing Freeze Columns (in the Form View)
If this answer solves your problem, please check, Mark as Answered . If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire
Shane Devenshire
Was this reply helpful?
An alternative to highlighting only the control with the focus or using Conditional Formatting on every control is to add a text box with BackColor set to whatever BackColor you use on the other controls. Size this text box to cover the entire detail section and use Format - Send to Back to put it behind all the other controls. Then select all the other controls and set their BackStyle to Transparent.
Next, add an invisible text box (named txtCurrent) to the form header or footer section (or even the detail section) and set its value in the form's Current event:
Me.txtCurrent = Me.[your primary key field]
Now, you can use CF on the one big text box to highlight the entire row. Use the Expression Is option with an expression like:
[your primary key field] = [txtCurrent]
and selecting the back color of your choice.
30 people found this reply helpful
·
Was this reply helpful?
Thank you so much! I have been trying every suggestion I could find, and yours works like a charm!
Was this reply helpful?
Thank you for the great code.
Was this reply helpful?
Hey Marshall,
I'm trying to follow what you are saying to do here but I'm having trouble. How are you coding this? Thanks in advance.
Forrest The Panda
Boiler Up and Go Big Blue
Was this reply helpful?
There is only the one line of VBA in the form's Current event procedure (not the OnCurrent event property). I thought I clearly(?) described all the details in my post, so can you provide more information about what part is causing you trouble.
Was this reply helpful?
Someone else explained your method to me so I get what you were saying now. You explained it clearly, I'm just new to Access and couldn't find the OnCurrent property. Thanks for the help.
Forrest The Panda
Boiler Up and Go Big Blue
Was this reply helpful?
I tried this but couldn't get it to work. When you say CF, what do you mean. Also, I did everything including selecting the text box and created an expression Forms!frmMaster_PriceBrand.txtCurrent.Backcolor = vborange. Then I tried vbyellow, and then #EEB500, and then just plain yellow, orange. No luck. What did I do wrong.
Was this reply helpful?
I tried this but couldn't get it to work. When you say CF, what do you mean. Also, I did everything including selecting the text box and created an expression Forms!frmMaster_PriceBrand.txtCurrent.Backcolor = vborange. Then I tried vbyellow, and then #EEB500, and then just plain yellow, orange. No luck. What did I do wrong.
1 person found this reply helpful
·
Was this reply helpful?
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/highlight-row-in-continuous-form/a862821f-ebee-4ebc-93d9-e068debcab84
0 Response to "Ms Access Continuous Form Height Based on Records"
Post a Comment