after update on form, bold text in table

  • Thread starter Thread starter alacali
  • Start date Start date
A

alacali

Hello there!
After user updates a field on the form, I want to bold text and change
background color for that cell in the underlying table and on the form view.
I then want to export that underlying table to excel with changes bold text
and changed background color visible. Is this possible and if so, how? I
don't have any code knowledge, so a "for Dummies" approach would be greatly
appreciated.

Thanks in advance.
 
Hello there!
After user updates a field on the form, I want to bold text and change
background color for that cell in the underlying table

You can't.

Tables are for data storage. Tables have very limited formatting
capabilities; unlike spreadsheets, fields ("cells") in a table don't
store their own formatting.
and on the form view.

YOu can use Conditional Formatting on a Form if there is a field in
the table indicating that the record is new.
I then want to export that underlying table to excel with changes bold text
and changed background color visible. Is this possible and if so, how? I
don't have any code knowledge, so a "for Dummies" approach would be greatly
appreciated.

You would have to open Excel and use (nontrivial) VBA code to
specifically set the format of the cells, using both the Access and
the Excel data models. I doubt that anybody's written a "for dummies"
guide to this complex task; I certainly would need a few hours' study
to feel comfortable even trying to do it, much less write a tutorial
for it!

John W. Vinson[MVP]
 
Back
Top