Preview Bug in Access 97 / 2000 , workaround

[LizardKingSchwing]

Hello

I have a report with richedit text boxes on it however if i preview this report which spans 2 pages the text boxes on page 1 do not show in preview, however they print out ok.

This is a bug in access below.

http://support.microsoft.com/support/kb/articles/Q212/7/33.ASP

Now what I wanted to change was to remove the text boxes and have labels instead. I try to change the text of a label via following code

Reports!GraphsDaily!BaseDate1!Value = dToday

however it does not update and shows this error

Error Desc:Object doesn't support this property or method
Error Source:log
Error Number:438

Anyone got any ideas as I need to change this by tomorrow

Cheers

LK--<

 

[Niv3k]

Can't you just use a regular text field, and set Can grow and can shrink to &quot;Yes&quot;? (In the format tab of the text fields properties)

Kevin

 

[LizardKingSchwing]

It happens with a normal text box tooo. When I open the Preview the normal text boxes are not shown on the 1st page but they print out ok.

Is it possible to update a label in code (and example plz)??

Cheers

LK--<

 

[Niv3k]

I played around a little bit, I think this should work. Set the Rich text box .Visible to false, but keep it on the form. Add your label, rename it to something appropriate. Then in the format event of the detail section add this line of code: (Change label0 to the correct name of the label)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Label0.Caption = Me.[Your field name]
End Sub

It seems to work for me, but then again, I am working with Access 97 and SP6 (?), and I didn't seem to be able to reproduce the error anyway.