Defining formats (i.e. bold, underline) for fields in forms/report

N

NewToAccess

I need to define formats (i.e. bold, underline) for reference table fields.
For example, let’s say reference table A contains three fields: Field1,
Field2, Field3 and two rows.
Reference Table A
ID _Num Field1 Field2 Field3
1 Single Double Triple
2 Single Double Quadruple

Forms need to know that for row 1 Double will be in bold and Triple will be
underlined. However, for row 2, only Quadruple need to display in bold on
forms, reports, etc.
 
J

John W. Vinson

I need to define formats (i.e. bold, underline) for reference table fields.
For example, let’s say reference table A contains three fields: Field1,
Field2, Field3 and two rows.
Reference Table A
ID _Num Field1 Field2 Field3
1 Single Double Triple
2 Single Double Quadruple

Forms need to know that for row 1 Double will be in bold and Triple will be
underlined. However, for row 2, only Quadruple need to display in bold on
forms, reports, etc.

You may be able to use Conditional Formatting on a Form or Report to do this.
Open the Form in design view, select the textbox for Field1, and choose
Format... Conditional Formatting from the menu.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top