Re: Auto Resize

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks John

This still doesn't work.
The Control (text box) is named: Trainees Name
and I am now using the expression: =[First Names] & " " [Last Name]

I still get the error:
The expression you entered contains an invalid syntax
You may have entered an operand without an operator

"John Spencer" wrote:

If your field names have spaces then you MUST surround them with square
brackets []. Also make sure you have spelled the names correctly and that
the control is NOT named the same as the fields you are using in the
expression.

=[First Names] & " " [Last Name]

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Bipbop" <Bipbop@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE9556B6-68B5-4B4A-B047-4DCDC693CA8D@xxxxxxxxxxxxxxxx
This is exactly what I want, (just first names and last name), but when I
create a text box in my report (certificate), and enter

=First Names & " " [Last Name]

I receive the error:

You have entered an operand without an operator.

What am I doing wrong?

"Marshall Barton" wrote:

Use a single text box with an expression like:

=Rank & " " & [First Name] & " " [Last Name]

--
Marsh
MVP [MS Access]




.

Relevant Pages

  • Re: Format Table or Form ?
    ... To see the actual values you need to build a query and link the main table with the tables that have the values you want to see. ... Access MVP 2002-2005, 2007-2008 ... Presumably I have to edit some of the Properties of the Table ?, or is this done via the Form control ?, and if so, What? ... "John Spencer" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Grouping a Report Based on a Value
    ... Set the control so its visible property is NO. ... Access MVP 2002-2005, 2007 ... "John Spencer" wrote: ... organization requires each "roster" be no greater than 99 records. ...
    (microsoft.public.access.reports)
  • Re: Format Table or Form ?
    ... Hi, Both combo's are now working OK, but I've noticed that the underlying ... Properties of the Table ?, or is this done via the Form control ?, and if so, ... "John Spencer" wrote: ... Access MVP 2002-2005, 2007-2008 ...
    (microsoft.public.access.gettingstarted)
  • Re: subtotal and grandtotal like items in a report
    ... Microsoft Access MVP ... "John Spencer" wrote: ... == Name the control something like SubTotalLabor ... Duane Hookom wrote: ...
    (microsoft.public.access.reports)
  • Re: Changing all controls on report to use white font
    ... "John Spencer" wrote: ... Access MVP 2002-2005, 2007-2008 ... Dim ctlAny as Control ... function call that would go through all controls and make the font white. ...
    (microsoft.public.access.reports)