Ellefant,
I would open the report in print preview mode. This allows the user to check that the information fits on the page etc- and that it is the correct thing to print.
the code to do this would be something like:
DoCmd.OpenReport reportname, acViewPreview , , strcriteria
or you could...
I can't spell Enumerating.
Having inspected the object browser, it doesn't look like I can do it with DAO or ADOX But surely the description for the field is held somewhere? as is the caption? Is it in the properties? Am I being stupid
Help
I should know the answer to this - but I can't seem to get it to work.
I need to copy the text from the table design view description property into the caption for each field name in each table in the database.
So I need to loop thru the tables (easy) then loop thru the fields collection for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.