Report text box not showing (1 Viewer)

[gazsharpe101]

Hi everyone,

I am running a report in Access 2003 to produce company standard letters. When the report is in design view and I click preview, it works fine but when I try to run it from the relevant form on the database, one of the text boxes doesn't show up and I don't know why.

Any ideas?

Thanks.
Gareth.

 

[KenHigg]

Do you have any of the controls properties set incorrectly? Like maybe the 'Visible' property? Do you have any code running in any of the events like 'On Open' or 'On Activate'?

 

[gazsharpe101]

Thanks for your response.

The box is set to visible as it displays when previewing it from design view.

I only have an event on the 'on print' of the detail section that the box is displayed in. The event determines the content of the box dependant on parameters that have been inputted by the user. Maybe this should be on the 'on format' event?

EDIT: Tried moving it to 'on format' event and seems to have worked. Should have tried that before.

Thanks.

 

[KenHigg]

Cool - Glad you have it working -