enter trim paremeter value occurs after creating labels

T

Tebenton

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

Allen Browne

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.
 
T

Tebenton

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.
 
C

Chuck

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
--
 
A

Allen Browne

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
 
T

Tebenton

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.
 
T

Tebenton

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.
 
A

Allen Browne

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

Top