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.

On Mon, 06 Nov 2006 00:48:07 GMT, "alacali" <u28715@uwe> wrote:

> 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]