Importing a file & fixed text

Hakutabe

New member
Local time
Today, 13:56
Joined
Jul 10, 2013
Messages
6
hello guys :) i have 2 questions

1. how do i import a word document as a template to ms access Report file i did Ctrl + A to select all copy then paste it pasted it well u can say good but when u preview its not an actual page size its much smaller and theres no way to re-size it is there a way to copy or import it perfectly to the report file in access?

and the second question
2. in a form where you choose source code (i think) i merged in 1 table the FirstName and LastName i remember doing something like
Code:
[FirstName] & " & [LastName]

now when i preview the report after selecting my data from combo box it prints fine i mean merges the FirstName and LastName to 1 box but its not a fixed position i mean i placed the text box above the line "Fullname:_______"
but when i preview it depending on the lenght of the table it moves too left or too right and i cant control it is there a way to fix its position? like it tell it where to start from or something that can help? because if the name is too short or too long the text just dances and i changing the position of the textbox doesnt really help
 
I've never had satisfactory results with this method. Most of the time you are better off just trying to format the report and use labels as the fixed text. For the times you want Word's free flowing ability to reformat itself as in a letter, I use OLE to automate Word to fill individual form fields or bookmarks. Mail merge also works well.
 
really? i dont know if u can populate a label from combobox selection can u?
 
What? Why do you need to populate a label from a combo? I thought we were talking about formatting?
 

Users who are viewing this thread

Back
Top Bottom