Database Field Switch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadunc - 28 Mar 2007 00:21 GMT

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=MS
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.

Signature

Reply to this Message

Peter Jamieson - 28 Mar 2007 08:36 GMT

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

>I have a database field connecting to a table as below:
>
[quoted text clipped - 10 lines]
> switch. The current one I'm using is just one of the default word table
> autoformats.

Reply to this Message