Report of Tabular Data with strange spacing

  • Thread starter Thread starter Grip
  • Start date Start date
G

Grip

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.).
 
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
John said:
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.).

Grip said:
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
Click to expand...
Click to expand...
 
Back
Top