Microsoft KB Archive/104566

From BetaArchive Wiki

Article ID: 104566

Article Last Modified on 1/18/2007



APPLIES TO

  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition



This article was previously published under Q104566

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

SYMPTOMS

A text box control does not display text in the color that 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 as follows:


Format: [Red];;[Yellow]

  1. Save and close the form.
  2. Open the Orders form in Form view. Note that the Discount field is not displayed in color.
  3. Close the Orders form. Open the Orders Subform form in Design view.
  4. Change the Format property of the Discount field as follows:


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

  1. Save and close the form.
  2. Open the Orders form in Form view. Note that the values in the Discount field are displayed 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 Discount text box control 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.


Additional query words: colour colours asked for wanted indicated set

Keywords: kbprb KB104566