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.

In the example above, what if I wanted the first row to be displayed on a
form as Triple, Single, Double and the second row to be displayed as Single,
double, quaruple?

Is there some clearly defined set of rules that is supposed
to apply here? You've posted this question in two different
groups and based on what you've described so far it sounds
like you want the application to apply custom formatting and
re-arrange field order, on a row by row basis, according to
what you randomly decide you want at any given time.

--
_________

Sean Bailey


"NewToAccess" wrote:

> 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.
>
> In the example above, what if I wanted the first row to be displayed on a
> form as Triple, Single, Double and the second row to be displayed as Single,
> double, quaruple?
>