saving prtdevmode in table

[Esmee]

Hi there,
I want to be able to save the PrtDevmode en Prtdevnames properties of
several reports into a table. So I open a report in Design mode, get
the prtdevmode en prtdevname from the report, tuern it into a string
and save them to Memo fields in a table. So far so good.

But then I want to get the prtdevmode and prtdevname out of the table
and save it into the report again. Then it goes wrong. When I look in
the table at first I only see part of the string, until I select the
whole field, and then I can see the whole string. There are squares in
the string. When extracting the prtdevmode and prtdevname I get only
the part of the string until the first square. Everything after that
doesn't come out of the table.
I'm pretty sure that's where the crux of the problem lies.
Does anyone have any suggestions how I can get the whole string out of
the table again?

It's getting to be very frustrating.
Thanks
Esmee

[TC]

The PrtDev* structures contain binary data - not ordinary string data. They
will inevitable look strange if you store them into a text column. The ideal
column type would be BINARY. But I don't have Access here to check, so I'm
not sure whether you can define a binary column directly from the user
interface.

As a matter of interest, *why* do you want to store the PrtDev* values?

HTH,
TC
"Esmee" <g.********@inspektor.nl> wrote in message
news:2e**************************@posting.google.c om...

Hi there,
I want to be able to save the PrtDevmode en Prtdevnames properties of
several reports into a table. So I open a report in Design mode, get
the prtdevmode en prtdevname from the report, tuern it into a string
and save them to Memo fields in a table. So far so good.

But then I want to get the prtdevmode and prtdevname out of the table
and save it into the report again. Then it goes wrong. When I look in
the table at first I only see part of the string, until I select the
whole field, and then I can see the whole string. There are squares in
the string. When extracting the prtdevmode and prtdevname I get only
the part of the string until the first square. Everything after that
doesn't come out of the table.
I'm pretty sure that's where the crux of the problem lies.
Does anyone have any suggestions how I can get the whole string out of
the table again?

It's getting to be very frustrating.
Thanks
Esmee

[Esmee]

Thanks TC, you put me on the right track.
The reason I want to be able to store PrtDev* values is so that my
clients don't have to change the printer settings of reports every
time I send them a new version of my db.
Bye
Esmee

"TC" <a@b.c.d> wrote in message news:<1066966987.768140@teuthos>...

The PrtDev* structures contain binary data - not ordinary string data. They
will inevitable look strange if you store them into a text column. The ideal
column type would be BINARY. But I don't have Access here to check, so I'm
not sure whether you can define a binary column directly from the user
interface.

As a matter of interest, *why* do you want to store the PrtDev* values?

HTH,
TC
"Esmee" <g.********@inspektor.nl> wrote in message
news:2e**************************@posting.google.c om...

Hi there,
I want to be able to save the PrtDevmode en Prtdevnames properties of
several reports into a table. So I open a report in Design mode, get
the prtdevmode en prtdevname from the report, tuern it into a string
and save them to Memo fields in a table. So far so good.

But then I want to get the prtdevmode and prtdevname out of the table
and save it into the report again. Then it goes wrong. When I look in
the table at first I only see part of the string, until I select the
whole field, and then I can see the whole string. There are squares in
the string. When extracting the prtdevmode and prtdevname I get only
the part of the string until the first square. Everything after that
doesn't come out of the table.
I'm pretty sure that's where the crux of the problem lies.
Does anyone have any suggestions how I can get the whole string out of
the table again?

It's getting to be very frustrating.
Thanks
Esmee