Adding Blank columns along with conditional formatting in a report

[nupur]

Hi!!

I have created a report in access which will populate based on the selection criteria in a form.
The report contains certain due dates for different stages of a process.
I want to add blank column in my report along with each due date field so that if anybody has passed the due date, he/she would be able to add a reason for that in blank columns.

I know that since report and form are connected to a database, adding blank column in database would automatically reflect on the report. But I cant change anything in the database.

Is this possible without making changes in the actual database. Also I want to add conditional formatting in those blank columns. (For eg: when somebody would enter anything in that column it would turn red).

I would appreciate your suggestions.

 

[Galaxiom]

Make another database with table that has a field for the primary key of the data you want to add a field to and a field for the comment. Link this table to the front end.

Modify the RecordSource query for the form and report to add a join to this table on the key. Add a textbox bound to the comment field to the form and report.

Just set the ForeColor of the new control to red. If there is nothing in it there won't be any red. If you mean to change the whole record colour then use an Expression Is condition in the ConditionalFormat of each control.

Not IsNull([commentfield])

 

[nupur]

Thank you!! You are awesome.
I just have one more question. Now that I have modified the query, whenever I open my form as well as report in the design view, it seems all blank. I have check the visibility in the properties section and everything looks good to me.
I can only view the fields for header section but nothing in detail section.

 

[Galaxiom]

Now that I have modified the query, whenever I open my form as well as report in the design view, it seems all blank.

That happens with subforms if the subform object (and probably its Recordsource query) is already opened directly. Should not happen otherwise.

I would restart Access if it persists.

 

[nupur]

Thank you
Can I make the end users add comments/reasons in the comments section in report I have previously created?
Does this requires VBA programming?