ACC: Formatted Colors Do Not Appear in Text

 Last reviewed: May 28, 1997
Article ID: Q104566
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

A text box control does not display text in the color you specified. Instead, the text is displayed as if you did not specify any color.

CAUSE

If you specify a color without a format in the Format property for a text box, no color will be displayed.

RESOLUTION

Specify both a format and a color in the Format property for the text box.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x or 2.0). Open the Orders Subform form in Design view.

  2. Change the Format property of the Discount text box to: 

          Format: [Red];;[Yellow]

  3. Save and close the form.

  4. Open the Orders form in Form view. Note that the Discount field does not display in color regardless of the value in the field.

  5. Close the Orders form. Open the Orders Subform form in Design view.

  6. Change the Format property of the Discount field to: 

          Format: 0.00%[Red];;0.00%[Yellow]

  7. Save and close the form.

  8. Open the Orders form in Form view. Note that the values in the Discount field display in red or yellow.

NOTE: To return the Orders subform back to normal, open the form in Design View and change the Format of the Text box control Discount back to percentage by selecting it from the combo box.

REFERENCES

For more information about formatting fields, search the Help Index for "Format property," or ask the Microsoft Access 97 Office Assistant.

Keywords : FmsHowto kbusage
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.