toylibrary
asked on
Microsoft Access - Continuous Forms and formatting each record individually
I have a complex database with heaps of forms and extensive use of subforms.
I sometimes have to use continuousforms in a subform and generally this is fine for simple lists of records.
However, I need to format each record for the following:
1. if record is archived, title is formatted with rd text. if not archived (ie current) then title should be green text.
2. a similar type date condition sets the background form colour to a different colour.
3. the value of a field determines if another field is displayed or enabled.
The problem comes when running the form - when scrolling through the continuous forms, the formatting is applied to all the forms. So, all the records will have the formatting of the last record in the cnt. form.
I think this is a problem which cant be "fixed".
I have tried using conditional formatting but this is linked to one field and only allows text colour or font changes. It doesnt allow visiblility properties to be set or enabled/locked settings. So this is not the answer.
I hope there is a solution as I cnt see another way around progamming this normally.
access-continous-forms-problem.jpg
I sometimes have to use continuousforms in a subform and generally this is fine for simple lists of records.
However, I need to format each record for the following:
1. if record is archived, title is formatted with rd text. if not archived (ie current) then title should be green text.
2. a similar type date condition sets the background form colour to a different colour.
3. the value of a field determines if another field is displayed or enabled.
The problem comes when running the form - when scrolling through the continuous forms, the formatting is applied to all the forms. So, all the records will have the formatting of the last record in the cnt. form.
I think this is a problem which cant be "fixed".
I have tried using conditional formatting but this is linked to one field and only allows text colour or font changes. It doesnt allow visiblility properties to be set or enabled/locked settings. So this is not the answer.
I hope there is a solution as I cnt see another way around progamming this normally.
access-continous-forms-problem.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank-you - I did not realise I could use CF to enable/disable as I didnt see that tiny button at the end!
This will have to suffice as the solution for now.
however,
LSMConsulting: - what are these 3rd party grids you mention? IS it an add-on?
It is not part of Access I assume so how would it be ultimately deployed/used in compiled version of the program?
This will have to suffice as the solution for now.
however,
LSMConsulting: - what are these 3rd party grids you mention? IS it an add-on?
It is not part of Access I assume so how would it be ultimately deployed/used in compiled version of the program?
They are ActiveX controls you can use in the Access environment. Deployment can be a bit of a hassle; normally there's a "runtime" version of the control that you would deploy and install on the enduser machine.
ASKER
Thanks for the information - I will have to research the use of ActiveX in Access. This particular database has over 150 users so I need to be very sure of deployment!
You could switch to a 3rd party grid control (Janus Gridex is one); this gives you full control over each individual cell in the grid.