Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
scubadunc scubadunc is offline
external usenet poster
 
Posts: 1
Default Database Field Switch

I have a database field connecting to a table as below:

{ DATABASE \d " C:\\database\\westernpacific.mdb " \c "DSN=MS Access
Database;DBQ= C:\\database\\westernpacific.mdb;DriverId=25;FIL=M S
Access;MaxBufferSize=512;PageTimeout=5;" \s " SELECT Policy.PolicyID AS
Product_ID, Policy.Institution AS Institution, Policy.PolicyDetails AS
Product_Type, Policy.Commence AS Commencement_Date
FROM Policy
WHERE (((Policy.CustID)='GavinDelaney30/01/1964'))"\l"6"\b "63" \h;}

My issue lies within the switches at the end of the statement. If I add a
custom table autoformat, how do I know what the format# is after the \l
switch. The current one I'm using is just one of the default word table
autoformats.
--
DM
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Database Field Switch

As far as I know, you can only specify the standard autoformats using \l and
there's no way to specify custom ones. It may be worth trying to apply
\*Mergeformat when you have achieved the format you want, but I doubt if it
can be relied on.

Peter Jamieson
"scubadunc" wrote in message
...
I have a database field connecting to a table as below:

{ DATABASE \d " C:\\database\\westernpacific.mdb " \c "DSN=MS Access
Database;DBQ= C:\\database\\westernpacific.mdb;DriverId=25;FIL=M S
Access;MaxBufferSize=512;PageTimeout=5;" \s " SELECT Policy.PolicyID AS
Product_ID, Policy.Institution AS Institution, Policy.PolicyDetails AS
Product_Type, Policy.Commence AS Commencement_Date
FROM Policy
WHERE (((Policy.CustID)='GavinDelaney30/01/1964'))"\l"6"\b "63" \h;}

My issue lies within the switches at the end of the statement. If I add a
custom table autoformat, how do I know what the format# is after the \l
switch. The current one I'm using is just one of the default word table
autoformats.
--
DM



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I switch to the next form field? D. Prigmore Microsoft Word Help 3 December 28th 06 03:53 AM
More than one formatting switch for a merge field sch06 Mailmerge 6 November 2nd 06 10:18 AM
numeric field picture switch Julie Microsoft Word Help 3 September 26th 05 09:39 PM
CardText Field Switch JoyceA Mailmerge 2 June 18th 05 11:05 AM
Problem using simple field Switch JohnB Mailmerge 4 June 15th 05 11:14 AM


All times are GMT +1. The time now is 01:33 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"