- Microsoft Access
Conditional Formatting Background On Continuous Form
I have a continuous form in my Access 2013 application. Each line is pre-populated with values (Year, Principal, Interest, Penalty, Lien Fess and Atty Fees) from the bound record. The bound fields are locked, no entry permissable.
Each line also has bound fields (NewPrincipal, NewInterest, etc..) pre-populated with the same values.
The user is permitted to change any of the bound values.
If the user changes any values in the 'New' fields I would like the background of that line of the continuous to be yellow. There can be many lines on the continuous form and not all will be changed. By making the background of any changed records yellow it would be easier for the users to keep track of which records had already been updated.
Each line also has bound fields (NewPrincipal, NewInterest, etc..) pre-populated with the same values.
The user is permitted to change any of the bound values.
If the user changes any values in the 'New' fields I would like the background of that line of the continuous to be yellow. There can be many lines on the continuous form and not all will be changed. By making the background of any changed records yellow it would be easier for the users to keep track of which records had already been updated.
If you change an unbound field's value then the new value is "propagated" to all the unbound records of that field...for example if you change NewPrincipal on some row ...you will see it will automatically get set all to all the rows of NewPrincipal
One method is to create a temp table which you fill with the fields and values as a copy of those fields in the current table that may be altered. Then bind your currently unbound textboxes to the fields of the temp table.
Now you can compare the field values of the main table with the field values of the corresponding fields in the temp table to see if they match. This information you can use in conditional formatting or something else that not is unbound.
John and Gustav: Thanks for you replies and as I read them I realized I hadn't described the form correctly. The 'New' prefix fields on the form are bound and the only fields on the form that the user can change.
The entire form is bound to a temp table. When the user has comleted all of there changes, they will submit the form and all changes will be applied to the live file. While they are making changes, which may be to multiple records on the continuous form, I would like any record they have made changes to to have the background changed to a different color (yellow?)
I've edited this question to describe this correctly.
The entire form is bound to a temp table. When the user has comleted all of there changes, they will submit the form and all changes will be applied to the live file. While they are making changes, which may be to multiple records on the continuous form, I would like any record they have made changes to to have the background changed to a different color (yellow?)
I've edited this question to describe this correctly.
Explore More Content
-
![]()
SolutionOrdering records on a continuous form -
![]()
ArticleSynchronizing subforms - What record is displayed on top of a continuous subform after using scrollbar? -
![]()
VideoHighlight the Current Record on an Access form with a Yellow background color -
![]()
Cloud Class®Certification: MOS Microsoft Office Specialist - Access 2016 Part 2
Explore More ContentExplore courses, solutions, and other research materials related to this topic.
-
![]()
received a Solution
Determine which record is displayed at top of continuous form when user uses the scroll bar to scroll down -
![]()
wrote an Article
![]()
Using multiple instances of a sub-form in a single form
-
![]()
created a Video
![]()
Using a Criteria Form with an Access Report
-
Explore Cloud Class® ![]()
Certification: MOS Microsoft Office Specialist - Access 2016 Part 3
Premium Content
You need an Expert Office subscription to comment.Start Free Trial