enter trim paremeter value occurs after creating labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After creating labels using the wizard. When label report runs Pop up window
asks for a Trim parameter value.
 
I don't understand.

When you attempt to open the report, a dialog pops up, and the title bar of
the dialog says:
Trim parameter value.

I've no idea what's going on with your report.
 
The top of the dialog in the blue bar next to ? X States Enter Parameter Value
Below that in the dialog box TRIM
Below that is the area to enter whatever it is asking for.
 
After creating labels using the wizard. When label report runs Pop up window
asks for a Trim parameter value.

In the properties for the label, what is entered for the Name, the Caption, the
ControlTip Text, and the Help Context Id?

Chuck
--
 
Trim() is a function that chops off any leading and trailing spaces.

The label wizard uses this function in the Control Source of the text boxes,
around expressions like this:
=Trim([FirstName] & " " & [Lastname])

If the report asks for just Trim, then the possibilities that come to mind
are:
a) You have a problem with library references;

b) The Control Source of a text box has been messed up, e.g. the expression
above is now just:
=Trim
 
I created the database at the office. Seems there is a reference to the
server address. I made another database at this computer & all works
correctly. How do I get a database created elsewhere to work at this
location. I want to develop the program from both sites?

Allen Browne said:
Trim() is a function that chops off any leading and trailing spaces.

The label wizard uses this function in the Control Source of the text boxes,
around expressions like this:
=Trim([FirstName] & " " & [Lastname])

If the report asks for just Trim, then the possibilities that come to mind
are:
a) You have a problem with library references;

b) The Control Source of a text box has been messed up, e.g. the expression
above is now just:
=Trim

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Tebenton said:
The top of the dialog in the blue bar next to ? X States Enter Parameter
Value
Below that in the dialog box TRIM
Below that is the area to enter whatever it is asking for.
 
Chuck, thank you I created the database at the office & there is a reference
problem to a server location. I have created a test database at home & all
the trim functions work correctly. How do I get a database created elsewhere
to work at a another computer that is not networked. I want to develop the
program working from both sites.
 
You have a problem with library references.

Please go back to the first reply you received, and follow the steps in the
article to rectify it.

I have nothing further to add to this thread.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Tebenton said:
I created the database at the office. Seems there is a reference to the
server address. I made another database at this computer & all works
correctly. How do I get a database created elsewhere to work at this
location. I want to develop the program from both sites?

Allen Browne said:
Trim() is a function that chops off any leading and trailing spaces.

The label wizard uses this function in the Control Source of the text
boxes,
around expressions like this:
=Trim([FirstName] & " " & [Lastname])

If the report asks for just Trim, then the possibilities that come to
mind
are:
a) You have a problem with library references;

b) The Control Source of a text box has been messed up, e.g. the
expression
above is now just:
=Trim

Tebenton said:
The top of the dialog in the blue bar next to ? X States Enter
Parameter
Value
Below that in the dialog box TRIM
Below that is the area to enter whatever it is asking for.

:

I don't understand.

When you attempt to open the report, a dialog pops up, and the title
bar
of
the dialog says:
Trim parameter value.

I've no idea what's going on with your report.

Trim parameter value.

:

You may have a problem with library references:
http://allenbrowne.com/ser-38.html

If that doesn't solve it, exactly what does the parameter window
ask
you
for?

After creating labels using the wizard. When label report runs
Pop
up
window
asks for a Trim parameter value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top