Inserting a database

  • Thread starter Thread starter Bob Wickham
  • Start date Start date
B

Bob Wickham

Hello,
When using the Insert Database command, is it possible to preserve the
formatting of the database table eg. currency OR is possible to format a
column in the resulting Word table ?

Thanks

Bob
 
Hi Bob,

AFAIK you need to create a query based on the table and create a
calculated field using the Format function. For example:

FormattedFieldName: Format([FieldName],"$0.00")

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Back
Top