Switch format characteristics cell-by-cell?

[Jonathan Ball]

I want to do something like this:

IIf([table_a].addr1 <> [tableb].addr1, SwitchToBold([tablea].addr1),
[tablea].addr1)

Is there such a function or set of functions, e.g. switch to italics
or change the font entirely? I can't find it and am not entirely sure
where to look.

Thanks in advance.

 

[Jerry Whittle]

Access doesn't have cells. Rather it has fields. Either way you can't do what
you want in a table or query. However you may be able to do it in a form or
report using Conditional Formatting. Press the F1 key while in Access and
type in "Conditional Formatting".

 

[John W. Vinson]

I want to do something like this:

IIf([table_a].addr1 <> [tableb].addr1, SwitchToBold([tablea].addr1),
[tablea].addr1)

Is there such a function or set of functions, e.g. switch to italics
or change the font entirely? I can't find it and am not entirely sure
where to look.

Thanks in advance.

Use a Form (table datasheets have very limited formatting and code potential),
and use Format... Conditional Formatting.

John W. Vinson [MVP]

 

[Jonathan Ball]

I want to do something like this:

IIf([table_a].addr1 <> [tableb].addr1, SwitchToBold([tablea].addr1),
[tablea].addr1)

Is there such a function or set of functions, e.g. switch to italics
or change the font entirely? I can't find it and am not entirely sure
where to look.

Thanks in advance.

Use a Form (table datasheets have very limited formatting and code potential),
and use Format... Conditional Formatting.

John W. Vinson [MVP]

Thanks to you and to Jerry Whittle.