Publish Report to Word - computed textbox value doesn't show

J

Jeri Morris

I have a report with a text field whose value is computed by a VB macro. It looks fine when I preview the report in Access, but when I click the "Publish with MS Word" button, the field is empty.

Any ideas?

Jeri
 
J

Jeri Morris

FYI, if the macro that computes the value puts it in a label field instead of a textbox field, the value *does*appear in the report when I publish it to Word. However, because the computed value is a text string whose length can vary, the field in which it is displayed needs to be able to grow as the length of the text grows. That works for a textbox field, but not a label field.

Jeri
 
Top