Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / November 2006

Tip: Looking for answers? Try searching our database.

Report of Tabular Data with strange spacing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Grip - 29 Nov 2006 17:05 GMT
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
John Spencer - 29 Nov 2006 17:11 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.