Copy form and paste to notepad

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to copy an Access Form and then paste it into Notepad so that
I can see the Form as VBA code?

Thanks,

Bill Morgan
 
Is there a way to copy an Access Form and then paste it into Notepad so that
I can see the Form as VBA code?

Thanks,

Bill Morgan
Click to expand...

Since the Form does not consist of VBA code, you cannot. A Form is
stored in Access' systems tables in an undocumented binary blob
object.

You can use the undocumented VBA Application.SaveAsText method to
write the form out to a (very verbose) text file; this is NOT VBA
code, though it will contain any VBA code that is in the Form's
Module. In the Immediate window try

Application.SaveAsText(acForm, "MyFormName", "E:\somepath\Filename")



John W. Vinson[MVP]
 
John. I had a vague memory of copying Access objects into Notepad as code -
thanks for the clarification ...
 
Back
Top