Access 2007 - Placing a portion of report text in a particular column

[Jim Boyd]

I'm using Access 2007 under Windows XP.

I'm creating a a multiline directory list for members of a club with three lines for each member.

Each listing has three textboxes and within the first textbox I have code like:
=Trim(lastname] &", " & [firstname] ...... & [Telephone]) with more fields where I show the ...... in this example.

I want the Telephone data to start at a specific column so that all Telephone data lines up. What do I add to insure this?

[ADezii]

The following code will precisely position the Telephone Numbers at Column 25. I used the [LastName], [FirstName], and [HomePhone] Fields from the Northwind Database for my code demo and will display the SQL along with the subsequent Output. In order for this logic to be effective, you must used a Fixed Width Font in Datasheet View, such as Courier:

1. SQL
   

   SELECT [LastName] & ", " & [FirstName] & Space$(25-Len([LastName] & ", " & [FirstName])) & [HomePhone] AS [Directory List]
   FROM Employees;

2. OUTPUT
   

               Directory List
   Davolio, Nancy           [phone]
   Fuller, Andrew           [phone]
   Leverling, Janet         [phone]
   Peacock, Margaret        [phone]
   Buchanan, Steven         [phone]
   Suyama, Michael          [phone]
   King, Robert             [phone]
   Callahan, Laura          [phone]
   Dodsworth, Anne          [phone]