Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Auto Size Fields In An Access Report

Discussion in 'Information Technology' started by Mettá, Jul 28, 2006.

  1. Mettá

    Mettá
    Expand Collapse
    Guest

    I have first name and last name in a report and want then to size according
    to the content so that I get

    FirstName Last Name

    or

    First Last

    and not

    First Last

    etc



    --
    ---
     
  2. Loading...


  3. OP
    freakazeud

    freakazeud
    Expand Collapse
    Guest

    Hi,
    make sure the controls can shrink and can grow properties are set to
    YES...you could then drag them to a really small size in design view and they
    should always grow/shrink to the appropriate size of the content they hold.
    HTH
    Good luck
    --
    Oliver
    Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    http://www.oli-s.de


    "Mettá" wrote:

    > I have first name and last name in a report and want then to size according
    > to the content so that I get
    >
    > FirstName Last Name
    >
    > or
    >
    > First Last
    >
    > and not
    >
    > First Last
    >
    > etc
    >
    >
    >
    > --
    > ---
    >
    >
    >
     
  4. OP
    Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Try concatenating the name in a query (or in the report) and using the
    result in a textbox. In a query column:

    FullName: [FirstName] & " " & [LastName]

    as the controlsource of a text box:

    = [FirstName] & " " & [LastName]
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Mettá" <Metta@remove-thismetta.org.uk> wrote in message
    news:#VQSXCwcGHA.1264@TK2MSFTNGP05.phx.gbl...
    > I have first name and last name in a report and want then to size

    according
    > to the content so that I get
    >
    > FirstName Last Name
    >
    > or
    >
    > First Last
    >
    > and not
    >
    > First Last
    >
    > etc
    >
    >
    >
    > --
    > ---
    >
    >
     
  5. OP
    fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 9 May 2006 01:35:20 +0100, Mettá wrote:

    > I have first name and last name in a report and want then to size according
    > to the content so that I get
    >
    > FirstName Last Name
    >
    > or
    >
    > First Last
    >
    > and not
    >
    > First Last
    >
    > etc


    Add an unbound control to the report.
    Set it's control source to:

    =[FirstName] & " " & [LastName]

    Make sure the name of this control is neither FirstName nor LastName.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  6. OP
    Mettá

    Mettá
    Expand Collapse
    Guest

    Thanks for the speedy response.

    M

    --
    ---
    "Mettá" <Metta@remove-thismetta.org.uk> wrote in message
    news:%23VQSXCwcGHA.1264@TK2MSFTNGP05.phx.gbl...
    >I have first name and last name in a report and want then to size according
    >to the content so that I get
    >
    > FirstName Last Name
    >
    > or
    >
    > First Last
    >
    > and not
    >
    > First Last
    >
    > etc
    >
    >
    >
    > --
    > ---
    >
    >
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page