Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    12

    Help with Field allignment in a report

    So I created this report that is a bill for my company's customers. I have a place for the field FirstName, LastName, Degree, Address, etc. I would like to have the a comma between the last name and degree, but mainly I would like to have the fields autofill to each of there true lengths and have the next field follow after a space.
    For example I want this: James Blake, MD, 1577 dkjfdk drive


    Not: James Blake MD 1577
    Thanks for any responses.

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    create one report field and in the ControlSource property concatenate your fields from the recordsource. Ex.:

    =Trim(FirstName & " " & LastName & ", " & iif(isnull(Degree),"", Degree & ", ") & Address)

  3. #3
    Join Date
    Jun 2010
    Posts
    12
    Thanks so much for the reply, I entered that in my control source property and it did try to insert them, but my filed names are actually First Name and Last Name, with a space in between. What should I do then. And how should I create this field? By adding the menu bar option saying Add Existing Field, or how should I do it?

  4. #4
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    Create a text box on the report. In the control source property of the text box, put

    =Trim([First Name] & " " & [Last Name] & ", " & iif(isnull(Degree),"", Degree & ", ") & Address)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Field alignment in report
    By RHall in forum Reports
    Replies: 1
    Last Post: 12-13-2014, 12:32 PM
  2. Referencing A Form Field In A Report
    By CGM3 in forum Reports
    Replies: 5
    Last Post: 07-01-2010, 08:16 PM
  3. Report keeps asking a for field value!
    By yobi4ever in forum Reports
    Replies: 2
    Last Post: 01-21-2010, 05:57 AM
  4. Run Report with Prompt for Field Criteria
    By diane802 in forum Reports
    Replies: 4
    Last Post: 01-15-2010, 02:31 AM
  5. sorting a field in report
    By Philangr8 in forum Reports
    Replies: 3
    Last Post: 08-26-2009, 05:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums