Bold Cells

[jcsports31]

How do you bold select cells in access 2007? I am trying to bold/italic/underline select cells but everytime I select bold it bolds the entire table. It even does this with changing text color or cell background. Any help would be great.

Thanks

[RuralGuy]

A cell is an Excel term. Access (an RDBMS) has fields and controls. In Datasheet view you will have problems such as you are describing.

[jcsports31]

is there anyway around that, so that I can note and easily recognize changes I made in the database with bold or italic?

[RuralGuy]

Not at the table level. In a form, possibly.

[weekend00]

Even in a form, some very technical code is needed to accomplish this.

[RuralGuy]

Even in a form, some very technical code is needed to accomplish this.

I was thinking of the Change event of a control and OldValue/NewValue. It of course would go away as soon as the record is saved.

[weekend00]

In a continuous form, it's easy to bold a column. but not a cell.

[RuralGuy]

I wonder if the same trick would work with Conditional Formatting and OldValue?

[weekend00]

I wonder if the same trick would work with Conditional Formatting and OldValue?

you are great man. conditional formatting is so perfect for this.

[RuralGuy]

Excellent! I take it you tried it and it works? I will file that away in my bag of tricks.

[weekend00]

Of course I tried, and it worked.

in the conditional format, there are 3 kind of condition:
1 Field value is
2 expression is
3 Field has focus

the third one is designed exact for this issue.

[RuralGuy]

I would think #2 would have worked closer to what the OP was requesting:
Me.ControlName <> Me.OldValue
...I only asked because I am real lazy in this area, sorry.

[weekend00]

I am lazy, but i am very boring right now, just keep refreshing the forum to find new post.