ACC: Data in Text Box Is Blank When Printed or Previewed

• Microsoft Access versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you print or preview a report or a form, a text box does not display data, even though the records have data in that field.

CAUSE

The text box control will be blank when you print or preview the form or report if the following conditions are true:

• The height of a text box control is smaller than the default height of the font selected for the text box.



• The CanShrink property is set to Yes.



• The CanGrow property is set to No.

RESOLUTION

Increase the height of the text box control by opening the report or form in Design view and using the mouse pointer to manually adjust the size of the text box to fit the font.

Change the CanGrow property to Yes. This enables the text box control to display data, but may adjust the alignment of data if the data extends past the width of the text box control.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.

MORE INFORMATION

Steps to Reproduce Problem

1. Open sample database Northwind.mdb.



2. Open the Customer Labels report in Design view.



3. Select the Address1Line control and change the following properties:
   

   
         Height: .15
         CanGrow: No
         CanShrink: Yes 




4. Preview the report. The Address1Line control is blank.

Keywords : kbusage RptLayou
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbbug