Jim-
Use the String function:
Control Source:
=[FirstName] & " " & [LastName] & String(100 – Len([FirstName] & [LastName]),
"_")
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-------------------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Thursday, April 12, 2012 8:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Sign in sheet report.
Hello All,
I would like to create a report that has the first and last names and a line
like below for a sign in sheet.
Jim Wagner____________________
John Doe ____________________
Frank Smith___________________
Is there a way to do this. or even have it like below
Jim Wagner____________________
John Doe______________________
Frank Smith___________________
Thank You
Jim Wagner
Tidak ada komentar:
Posting Komentar