Auto size fields in an Access report

#1 (**permalink**) 28-Jul-2006, 07:59 AM

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9164-auto-size-fields-in-access-report.html

--
---

*

#2 (**permalink**) 28-Jul-2006, 07:59 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
>
> FirstName Last Name
>
> or
>
> First Last
>
> and not
>
> First Last
>
> etc
>
>
>
> --
> ---
>
>
>

#3 (**permalink**) 28-Jul-2006, 07:59 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Mettá" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
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
>
>
>
> --
> ---
>
>

#4 (**permalink**) 28-Jul-2006, 07:59 AM

On Tue, 9 May 2006 01

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
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
I do not reply to personal e-mail

#5 (**permalink**) 28-Jul-2006, 07:59 AM

Thanks for the speedy response.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164

M

--
---
"Mettá" wrote in message
news:%23VQSXCwcGHA.1264@TK2MSFTNGP05.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9164
>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
>
>
>
> --
> ---
>
>