Hello,
maybe somebody can help me to solve my following problem:

I'm working with VB5 and CR 4.6. In order to print labels with data from
an Access-
Database I want to use a OCX-Control for printing barcodes. One field in
the DB and
therefore in the report contains the digits for the barcode. I can
insert the barcode-field - a rectangle - in the detail section ("Insert
- Object...") and I can type digits into the .text-property of the
OCX-control. The control translates the digits into bars - but this
works only in draft mode via manually typing...

Is there a way to pass the content from one DB-/Report-Field to the
Control with VB or CR like

"CrystalReport.OCXFieldname.Text = CrystalReport.barcodedigitfield.Text"

or something similar???

BTW: When using a formula-field the OCX-Control-Field is not shown in
the
expression editor.

Or is the only way to print barcode labels to fill a VB-Form with data
and print
the form with the .PrintForm-method? I can't believe...

Thanks for any help/suggestion

Robert Stahlbock
Hamburg/Germany

If the data is a char field in the database, then all you need do (!!) is

        StringToCode39 ({your_table.your_field})

2. Set the font as Code39-digits.

Note, the above is for data which can be expressed as Code39
barcodes. A working (and workable) font for these is shipped with
CR - c39digit.ttf - at least with the standalone versions of CR.

Warning: other barcode fonts with CR DON'T WORK!!

--
Les Schmalzbach
(remove nospam- to reply).

There are also available ($$ or is DMDM?) barcode fonts and callable
formula functions from Azalea (US) and CIA (UK, no relation I hope)
which include 2 of 5.

Neither is cheap, and beware: their freebie downloads are functionally
impaired.

--
Les Schmalzbach
(remove nospam- to reply).

Robert,

In my experience, CR can act as an OLE container for certain insertable
objects,
eg. Word documents and some OCXs.

However, in all cases the object must be either linked (from a file) or
embedded.
Unless the object/OCX itself has a mechanism (when inserted into a Crystal
report) to extract data from a database, then my short answer to your
question
is "I don't think this can be done".

CR6 introduces the concepts of the "Active Data Driver" and the "Crystal
Data
Object" which (allegedly) allow *any* sort of data to be passed for
reporting
from a calling VB program. However, we are still investigating this new
functionality - I have not yet tried passing "complex" data like images and
RTF text to CR6.

Regards,
Les Schmalzbach
(remove nospam- to reply).