Please proofread my syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Odniel - 16 Jan 2006 19:06 GMT

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

Reply to this Message

Marshall Barton - 16 Jan 2006 19:45 GMT

>Please tell me what is wrong with this line:
>
[quoted text clipped - 5 lines]
>
>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?

Signature

Marsh
MVP [MS Access]

Reply to this Message

Odniel - 16 Jan 2006 20:00 GMT

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:
> >
[quoted text clipped - 12 lines]
> Are you sure that you copied the function into your module
> correctly?

Reply to this Message

George Nicholson - 16 Jan 2006 19:55 GMT

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

Signature

George Nicholson

Remove 'Junk' from return address.

> Please tell me what is wrong with this line:
>
[quoted text clipped - 5 lines]
>
> http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

Reply to this Message

Odniel - 16 Jan 2006 20:36 GMT

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.
[quoted text clipped - 8 lines]
> >
> > http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

Reply to this Message

BruceM - 16 Jan 2006 20:37 GMT

Hmm?

> Yes.
>
[quoted text clipped - 17 lines]
>> >
>> > http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

Reply to this Message

BruceM - 16 Jan 2006 20:55 GMT

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?
>
[quoted text clipped - 20 lines]
>>> >
>>> > http://office.microsoft.com/en-us/assistance/HA011494721033.aspx

Reply to this Message