Combining forename and surname fields in report
in [Reports]
|
Prev: Accessing SQL Server Table-Valued Function from Access front-end
Next: drawing excel like grids on access reports
From: John Spencer on 16 Apr 2010 17:07 Reports have controls. Controls have Control Source properties. A control source can be a reference to a field or it can be an expression. Control's have a name property. In a control, you can use the following as the source =[FirstNameField] * " " & [LastNameField] If the control's name property is FirstNameField, then Access will generate an error as it won't "know" if you are attempting to refer to the field FirstNameField in the table or to the control with the same name. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County SamMexico via AccessMonster.com wrote: > Thanks John, I presume I'll find the control in the field properties...? >
From: SamMexico via AccessMonster.com on 19 Apr 2010 04:02
Daryl and John, thanks for your help - it works perfectly now! Sam -- Message posted via http://www.accessmonster.com |