Please proofread my syntax

[Odniel]

Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a single
textbox with the abovementioned line as the Control Source if I want to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

 

[Marshall Barton]

Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a single
textbox with the abovementioned line as the Control Source if I want to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

There is noting wrong with that line, although the use of a
field named WIDTH is suspicious. What error are you
getting?

Are you sure that you copied the function into your module
correctly?

 

[George Nicholson]

Did you copy the CanShrinkLines function from that article into your
database, per its instructions? The line you showed us requires it.

 

[Odniel]

The article example is:

=CanShrinkLines([Name],[Address1],[Address2],
Trim([City]) & (", " + [Region]) & " " & [PostalCode],[Country])

I substituted all the fields with mine. However, I omitted the ampersands
and quotations because I don't want several fields to show on the same line.

When I try to view the report in Print Preview, I get prompted for a
CanShrinkLines parameter.

About the width field... I have a field called WIDTH. When I first inserted
the expression, I left out the "Report!" and Access autocorrected "[WIDTH]"
to "[Width]." So I deleted the entire sentence and recreated it using the
Expression Builder. Clicking on the WIDTH field resulted in "Report!WIDTH."

Do you think I should rename the field to avoid a conflict in Access?

Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a single
textbox with the abovementioned line as the Control Source if I want to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

There is noting wrong with that line, although the use of a
field named WIDTH is suspicious. What error are you
getting?

Are you sure that you copied the function into your module
correctly?

 

[Odniel]

Yes.

I solved this particular issue by clearing out the extra space in each
record under the CONTENT 2 column in the table.

Thanks, though.

Did you copy the CanShrinkLines function from that article into your
database, per its instructions? The line you showed us requires it.

--
George Nicholson

Remove 'Junk' from return address.

Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a single
textbox with the abovementioned line as the Control Source if I want to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

 

[BruceM]

Hmm?

Yes.

I solved this particular issue by clearing out the extra space in each
record under the CONTENT 2 column in the table.

Thanks, though.

Did you copy the CanShrinkLines function from that article into your
database, per its instructions? The line you showed us requires it.

--
George Nicholson

Remove 'Junk' from return address.

Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a
single
textbox with the abovementioned line as the Control Source if I want to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no
information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

 

[BruceM]

Hit the send button a little too soon. What do you mean "extra space in
each record under the CONTENT 2 column"? Not sure what you're getting at,
but you may want to look at the Nz function.

Hmm?

Yes.

I solved this particular issue by clearing out the extra space in each
record under the CONTENT 2 column in the table.

Thanks, though.

Did you copy the CanShrinkLines function from that article into your
database, per its instructions? The line you showed us requires it.

--
George Nicholson

Remove 'Junk' from return address.



Please tell me what is wrong with this line:

=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])


The following Microsoft knowledgebase article told me to create a
single
textbox with the abovementioned line as the Control Source if I want
to
activate the CanShrink for "CONTENT 2" if "CONTENT 2" has no
information:

http://office.microsoft.com/en-us/assistance/HA011494721033.aspx