Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I switch to the next form field? | Microsoft Word Help | |||
More than one formatting switch for a merge field | Mailmerge | |||
numeric field picture switch | Microsoft Word Help | |||
CardText Field Switch | Mailmerge | |||
Problem using simple field Switch | Mailmerge |