By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Access:exporting memo field to RTF

P: n/a
ICU
Hi,

I have an Access 2000 app that is correctly updating a memo field in
the database from an ActiveXCTL but when I try to export that data to
a RTF the file is created but it is blank. It appears to be related to
the number of characters in that field??

Suggestions?

thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
First thing to check is that any changes in your form have been saved before
the export, e.g.:
If Me.Dirty Then
Me.Dirty = False
End If

There was a problem with RTF exports under A97. Details:
http://support.microsoft.com/?id=288877

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ICU" <km*******@hotmail.com> wrote in message
news:13**************************@posting.google.c om...

I have an Access 2000 app that is correctly updating a memo field in
the database from an ActiveXCTL but when I try to export that data to
a RTF the file is created but it is blank. It appears to be related to
the number of characters in that field??

Nov 12 '05 #2

P: n/a
This is the first time I see this way of saving the actual the record. So
Me.Dirty = False does the same job as Docmd.Runcommand acCmdSaveRecord ?
First thing to check is that any changes in your form have been saved before the export, e.g.:
If Me.Dirty Then
Me.Dirty = False
End If

Nov 12 '05 #3

P: n/a
Hi Saintor

Yes. Me.Dirty is the only reliable way to save a record in a specified form.

RunCommand acCmdSaveRecord saves in whatever form is active.

The wizard-generated DoMenuItem is also dependant on which form is active
(as well as what menus).

Me.Refresh does not generate any error if the save did not work, so is not
useful.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Saintor" <sa******@REMOVETHIShotmail.com> wrote in message
news:i%*********************@weber.videotron.net.. .
This is the first time I see this way of saving the actual the record. So
Me.Dirty = False does the same job as Docmd.Runcommand acCmdSaveRecord ?
First thing to check is that any changes in your form have been saved

before
the export, e.g.:
If Me.Dirty Then
Me.Dirty = False
End If

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.