Hi, I'd appreciate any advice.
I have a report with 4 fields:
1. ID (number)
2. Title in English (text)
3. Title in Spanish (text)
4. Description (memo)
5. Icon (OLE Embedded bmp)
The report I want should look like a table:
________________________________________
Icon | ID | Title | Description
________________________________________
| 1 | How are you? | This is the (memo)
| | Como estas? | multiline description
| | | that should appear
| | | breaking naturally
What I get however, is:
________________________________________
Icon | ID | Title | Description
________________________________________
| 1 | How are you? | This is the (memo)
| | | multiline description
| | | that should appear
| | | breaking naturally
| | Como estas? |
This is supposed to look like a table, is there a way for me to have
the Spanish title appear right below the English title?
As an aside, I have created a MSWord Mail Merge that queries the
database and imports the data to an actual table in a Word doc, however
Word can't seem to pull in the embedded icon.
Thanks for any suggestions you may have.
Cheers,
Colin
Build a concatenated field in your query and use that in the report .
Field: CombinedTitle: [EnglishText}& Chr(13) & Chr(10) & [SpanishText]
Export to word using Access' built-in capability means you can only export
text (no graphic objects - lines, icons, squares, checkboxes, etc.).
> Hi, I'd appreciate any advice.
>
[quoted text clipped - 37 lines]
> Cheers,
> Colin
Grip - 29 Nov 2006 21:24 GMT
Thanks John -- I really appreciate your help ...
One of your brackets was a } not a ], so I had a little trouble, but in
troubleshooting what was supposed to be happening, I learned a great
many things about where I can do the query from (either in the report
by building an expression associated in a textbox or with a dedicated
query, I am sure there are more).
You got me going on the right path -- thanks!
Colin
> Build a concatenated field in your query and use that in the report .
>
[quoted text clipped - 44 lines]
> > Cheers,
> > Colin