Forum Home
Press F1
Thread ID: 29418	2003-01-19 08:50:00	Formatting report in MS Access	tbacon_nz (865)	Press F1

Post ID	Timestamp	Content	User
115217	2003-01-19 08:50:00	I recently accidentally came across a reference in the MS Access help to a way to locate stuff at a specific position on a report page. Now I think I actually want to do it and of course can't find the reference again. I remember it had a warning about the possibility of print overlapping if this was done. Does anyone have ANY idea what I might have seen? TIA	tbacon_nz (865)
115218	2003-01-20 00:35:00	Ummm How about Left and Top? You can use the Left and Top properties to specify an object's location on a form or report. For example, you might want a control to be always positioned in the upper-right corner of a section. Setting A control's location is the distance measured from its left or top border to the left or top edge of the section containing the control. Setting the Left or Top property to 0 places the control's edge at the very left or top of the section. To use a unit of measurement different from the setting in the Regional Settings Properties dialog box in Windows Control Panel, specify the unit, such as cm or in (for example, 3 cm or 2 in). In Visual Basic, use a numeric expression to set the value of this property. Values are expressed in twips. For controls, you can set these properties by using a control's property sheet, a macro, or Visual Basic. For reports, you can set these properties only by using a macro or event procedure in Visual Basic while the report is in Print Preview or being printed. Remarks When you move a control, its new Left and Top property settings are automatically entered in the property sheet. When you view a form or report in Print Preview or when you print a form, a control's location is determined by its Left and Top property settings along with the margin settings in the Page Setup dialog box, available by clicking Page Setup on the File menu. For reports, the Top property setting is the amount the current section is offset from the top of the page; the Left property setting is the amount the current section is offset from the left edge of the page. Both property settings are expressed in twips. You can use these properties to specify how far down the page you want a section to print in the section's Format event procedure. Cheers, Alan Carpenter	Alan Carpenter (540)
115219	2003-01-20 01:03:00	Thanks for that Alan, I did see left and top, and it may do what I want, but the text of the help doesn't agree with my (vague) memory of what I originally saw, which seemed more appropriate at the time. Do you think MS employs a team of people to deliberately write confusing and unhelpful help so that all the punters will go out and buy MS Press books as well as the actual software? :D	tbacon_nz (865)
115220	2003-01-20 02:12:00	> Thanks for that Alan, > > I did see left and top, and it may do what I want, > but the text of the help doesn't agree with my > (vague) memory of what I originally saw, which seemed > more appropriate at the time. I've found that Top & Left for Controls combined with CurrentX and CurrentY for text let me put things almost anywhere on the report except, of course, for exactly where I want. Have a glance at ScaleMode as well, along with the other ScaleWhatEver properties. > Do you think MS employs a team of people to > deliberately write confusing and unhelpful help so > that all the punters will go out and buy MS Press > books as well as the actual software? :D It's not a team. For a team to work successfully, it needs a good Help File on how to work together, and some comprehension of how a Help fileworks. :D Cheers, Alan Carpenter	Alan Carpenter (540)
115221	2003-01-20 05:06:00	So now we know Alinghi's secret! I'll check out scalexx as well, although I think I have worked out a way to achieve what I want by a totally different means. Thanks for your assistance.	tbacon_nz (865)
1