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

  • Thread starter Thread starter NewToAccess
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Back
Top