Cascading text based on field input

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

Guest

I need to create a paragraph of text that will break differently based on a
field that is either 7 or 16 characters long. I tried creating an text box
with an IIF statement, but the text I need is more that 255 characters.
Basically it would be one paragraph if it the field value is only 7
characters, with that field in the middle of the paragraph. And a different
paragraph if the field value is 16 characters.

Any help would be appreciated.

Thanks,
 
I have a field that will contain one of two types of data i.e. "1234567" or
"1234567, 8901234"

Now I have to format the paragraph so that it would look something like this

If it is the 7 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the style, color and size indicated by the Item and/or UPC number
on the claim actually refers to an item that was not billed, or shipped, on
this invoice. Additionally, after reviewing the Purchase Order I have found
that Item No. 1234567 was not ordered for this store. Therefore, I am
providing a copy of the claim, invoice, proof of delivery, Order inquiry,
carton content and the Wal*Mart form for the claim below as a request to
reverse this claim.

if it is the 16 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the styles, colors and sizes indicated by the Item and/or UPC
numbers on the claim actually refers to an items that were not billed, or
shipped, on this invoice. Additionally, after reviewing the Purchase Order I
have found that Item Nos. 1234567, 8901234 were not ordered for this store.
Therefore, I am providing a copy of the claim, invoice, proof of delivery,
Order inquiry, carton content and the Wal*Mart form for the claim below as a
request to reverse this claim

Keep in mind that the field will appear within the paragraph so the
paragraph line breaks will be different with each different number of
characters.

Hope this helps
 
I have a field that will contain one of two types of data i.e. "1234567" or
"1234567, 8901234"

Now I have to format the paragraph so that it would look something like this

If it is the 7 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the style, color and size indicated by the Item and/or UPC number
on the claim actually refers to an item that was not billed, or shipped, on
this invoice. Additionally, after reviewing the Purchase Order I have found
that Item No. 1234567 was not ordered for this store. Therefore, I am
providing a copy of the claim, invoice, proof of delivery, Order inquiry,
carton content and the Wal*Mart form for the claim below as a request to
reverse this claim.

if it is the 16 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the styles, colors and sizes indicated by the Item and/or UPC
numbers on the claim actually refers to an items that were not billed, or
shipped, on this invoice. Additionally, after reviewing the Purchase Order I
have found that Item Nos. 1234567, 8901234 were not ordered for this store.
Therefore, I am providing a copy of the claim, invoice, proof of delivery,
Order inquiry, carton content and the Wal*Mart form for the claim below as a
request to reverse this claim

Keep in mind that the field will appear within the paragraph so the
paragraph line breaks will be different with each different number of
characters.

Hope this helps
Click to expand...

Am I correct that the only difference between the 2 paragaraphs is
that an "s" is added to Item No(s) and "were" is substituted for "was"
immediately after the number is inserted?

1) The easiest way is to break your paragraph into 2 separate fields.
[Paragraph1] is up to and including the words ItemNo (without the
period)
[Paragraph2] starts with the words "not ordered ... etc."

Then simply concatenate the full paragraph in the report.

In an unbound control on the report:

=IIf(Len([NumberField]) = 7, [Paragraph1] & ". " & [NumberField] & "
was " & [Paragraph2],[Paragraph1] & "s. " & [NumberField] & " were " &
[Paragraph2])


2) If you can't split the paragraph into 2 fields you need a bit more
work (and if you then change the first part, you must also change this
control to account for the change in length).

Using an unbound control in the report:
** Air code just to give you an idea ***

=IIf(Len([NumberField]) = 7, Left([Paragraph],X) & ". " &
[NumberField] & " " & Mid([Paragraph, X+2), Left([Paragraph],X) & "s.
" & [NumberField] & " were " & Mid([Paragraph],X+4))

Change X to what ever the number of characters there are
through Item No

Upkeep would be simpler splitting the paragraph into 2 fields and
using the first method.
 
That seems reasonable. So I would assume I would create two hidden objects
containing paragraph 1 and paragraph 2 and then call those into the unbound
field?

Sorry if this sound dumb, but I am just starting to use reports.

fredg said:
I have a field that will contain one of two types of data i.e. "1234567" or
"1234567, 8901234"

Now I have to format the paragraph so that it would look something like this

If it is the 7 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the style, color and size indicated by the Item and/or UPC number
on the claim actually refers to an item that was not billed, or shipped, on
this invoice. Additionally, after reviewing the Purchase Order I have found
that Item No. 1234567 was not ordered for this store. Therefore, I am
providing a copy of the claim, invoice, proof of delivery, Order inquiry,
carton content and the Wal*Mart form for the claim below as a request to
reverse this claim.

if it is the 16 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the styles, colors and sizes indicated by the Item and/or UPC
numbers on the claim actually refers to an items that were not billed, or
shipped, on this invoice. Additionally, after reviewing the Purchase Order I
have found that Item Nos. 1234567, 8901234 were not ordered for this store.
Therefore, I am providing a copy of the claim, invoice, proof of delivery,
Order inquiry, carton content and the Wal*Mart form for the claim below as a
request to reverse this claim

Keep in mind that the field will appear within the paragraph so the
paragraph line breaks will be different with each different number of
characters.

Hope this helps
Click to expand...

Am I correct that the only difference between the 2 paragaraphs is
that an "s" is added to Item No(s) and "were" is substituted for "was"
immediately after the number is inserted?

1) The easiest way is to break your paragraph into 2 separate fields.
[Paragraph1] is up to and including the words ItemNo (without the
period)
[Paragraph2] starts with the words "not ordered ... etc."

Then simply concatenate the full paragraph in the report.

In an unbound control on the report:

=IIf(Len([NumberField]) = 7, [Paragraph1] & ". " & [NumberField] & "
was " & [Paragraph2],[Paragraph1] & "s. " & [NumberField] & " were " &
[Paragraph2])


2) If you can't split the paragraph into 2 fields you need a bit more
work (and if you then change the first part, you must also change this
control to account for the change in length).

Using an unbound control in the report:
** Air code just to give you an idea ***

=IIf(Len([NumberField]) = 7, Left([Paragraph],X) & ". " &
[NumberField] & " " & Mid([Paragraph, X+2), Left([Paragraph],X) & "s.
" & [NumberField] & " were " & Mid([Paragraph],X+4))

Change X to what ever the number of characters there are
through Item No

Upkeep would be simpler splitting the paragraph into 2 fields and
using the first method.
Click to expand...
 
I can not figure what object you used to hold the paragraph information?

fredg said:
I have a field that will contain one of two types of data i.e. "1234567" or
"1234567, 8901234"

Now I have to format the paragraph so that it would look something like this

If it is the 7 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the style, color and size indicated by the Item and/or UPC number
on the claim actually refers to an item that was not billed, or shipped, on
this invoice. Additionally, after reviewing the Purchase Order I have found
that Item No. 1234567 was not ordered for this store. Therefore, I am
providing a copy of the claim, invoice, proof of delivery, Order inquiry,
carton content and the Wal*Mart form for the claim below as a request to
reverse this claim.

if it is the 16 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the styles, colors and sizes indicated by the Item and/or UPC
numbers on the claim actually refers to an items that were not billed, or
shipped, on this invoice. Additionally, after reviewing the Purchase Order I
have found that Item Nos. 1234567, 8901234 were not ordered for this store.
Therefore, I am providing a copy of the claim, invoice, proof of delivery,
Order inquiry, carton content and the Wal*Mart form for the claim below as a
request to reverse this claim

Keep in mind that the field will appear within the paragraph so the
paragraph line breaks will be different with each different number of
characters.

Hope this helps
Click to expand...

Am I correct that the only difference between the 2 paragaraphs is
that an "s" is added to Item No(s) and "were" is substituted for "was"
immediately after the number is inserted?

1) The easiest way is to break your paragraph into 2 separate fields.
[Paragraph1] is up to and including the words ItemNo (without the
period)
[Paragraph2] starts with the words "not ordered ... etc."

Then simply concatenate the full paragraph in the report.

In an unbound control on the report:

=IIf(Len([NumberField]) = 7, [Paragraph1] & ". " & [NumberField] & "
was " & [Paragraph2],[Paragraph1] & "s. " & [NumberField] & " were " &
[Paragraph2])


2) If you can't split the paragraph into 2 fields you need a bit more
work (and if you then change the first part, you must also change this
control to account for the change in length).

Using an unbound control in the report:
** Air code just to give you an idea ***

=IIf(Len([NumberField]) = 7, Left([Paragraph],X) & ". " &
[NumberField] & " " & Mid([Paragraph, X+2), Left([Paragraph],X) & "s.
" & [NumberField] & " were " & Mid([Paragraph],X+4))

Change X to what ever the number of characters there are
through Item No

Upkeep would be simpler splitting the paragraph into 2 fields and
using the first method.
Click to expand...
 
I can not figure what object you used to hold the paragraph information?

fredg said:
I have a field that will contain one of two types of data i.e. "1234567" or
"1234567, 8901234"

Now I have to format the paragraph so that it would look something like this

If it is the 7 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the style, color and size indicated by the Item and/or UPC number
on the claim actually refers to an item that was not billed, or shipped, on
this invoice. Additionally, after reviewing the Purchase Order I have found
that Item No. 1234567 was not ordered for this store. Therefore, I am
providing a copy of the claim, invoice, proof of delivery, Order inquiry,
carton content and the Wal*Mart form for the claim below as a request to
reverse this claim.

if it is the 16 digit field it would look like this:

I am taking exception to your reply indicating that the claim listed below
refers to a concealed shortage. I have reviewed this claim thoroughly to
find that the styles, colors and sizes indicated by the Item and/or UPC
numbers on the claim actually refers to an items that were not billed, or
shipped, on this invoice. Additionally, after reviewing the Purchase Order I
have found that Item Nos. 1234567, 8901234 were not ordered for this store.
Therefore, I am providing a copy of the claim, invoice, proof of delivery,
Order inquiry, carton content and the Wal*Mart form for the claim below as a
request to reverse this claim

Keep in mind that the field will appear within the paragraph so the
paragraph line breaks will be different with each different number of
characters.

Hope this helps

:

I'm afraid I can't even begin to imagine what you are trying to do. Could
you provide an example?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

I need to create a paragraph of text that will break differently based on a
field that is either 7 or 16 characters long. I tried creating an text
box
with an IIF statement, but the text I need is more that 255 characters.
Basically it would be one paragraph if it the field value is only 7
characters, with that field in the middle of the paragraph. And a
different
paragraph if the field value is 16 characters.

Any help would be appreciated.

Thanks,
Click to expand...

Am I correct that the only difference between the 2 paragaraphs is
that an "s" is added to Item No(s) and "were" is substituted for "was"
immediately after the number is inserted?

1) The easiest way is to break your paragraph into 2 separate fields.
[Paragraph1] is up to and including the words ItemNo (without the
period)
[Paragraph2] starts with the words "not ordered ... etc."

Then simply concatenate the full paragraph in the report.

In an unbound control on the report:

=IIf(Len([NumberField]) = 7, [Paragraph1] & ". " & [NumberField] & "
was " & [Paragraph2],[Paragraph1] & "s. " & [NumberField] & " were " &
[Paragraph2])

2) If you can't split the paragraph into 2 fields you need a bit more
work (and if you then change the first part, you must also change this
control to account for the change in length).

Using an unbound control in the report:
** Air code just to give you an idea ***

=IIf(Len([NumberField]) = 7, Left([Paragraph],X) & ". " &
[NumberField] & " " & Mid([Paragraph, X+2), Left([Paragraph],X) & "s.
" & [NumberField] & " were " & Mid([Paragraph],X+4))

Change X to what ever the number of characters there are
through Item No

Upkeep would be simpler splitting the paragraph into 2 fields and
using the first method.
Click to expand...
Click to expand...

A Field (Memo Datatype) in your table.
Or better yet, as I suggested, 2 memo fields stored in your table, and
included in the Report's record source.
 
Back
Top