Help on odd requirement

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

I have a standard Purchase order, form and report consisting of a main form
and a main report with "header information" and a sub-form/sub-report with
line items. The line items consist of an item number, qty, standard price,
special price.



The problem is I have to add an "extended description." But I only need to
have an extended description on some items, under special circumstances.
Can anyone think of a way to do this????



Any help is greatly appreciated.
 
I have a standard Purchase order, form and report consisting of a main form
and a main report with "header information" and a sub-form/sub-report with
line items. The line items consist of an item number, qty, standard price,
special price.



The problem is I have to add an "extended description." But I only need to
have an extended description on some items, under special circumstances.
Can anyone think of a way to do this????
Click to expand...

Simply add a Text field (for up to 255 bytes of description; Memo if
the descriptions will be more verbose) to the LineItems table; include
it on the form and the report. If there is no extended description for
an item, just leave it blank - Access doesn't store blank fields on
disk so it won't waste any space.

John W. Vinson[MVP]
 
Thank you for the responses.

I can add the extended description column but can I hide a second print line
on the form and the report if the extended description doesn't exist. I
would prefer that the blank line doesn't appear if the extended description
is not present. That way the printed forms do not appear to be
double-spaced. I can't switch the form to landscape to fit the extra text.
 
I can add the extended description column but can I hide a second print line
on the form and the report if the extended description doesn't exist. I
would prefer that the blank line doesn't appear if the extended description
is not present. That way the printed forms do not appear to be
double-spaced. I can't switch the form to landscape to fit the extra text.
Click to expand...

I'd just use a small textbox on the Form; the user can zoom the
textbox with Alt-F2 if they wish to be verbose, or just keep typing
(they won't be able to see the whole field content).

On the Report, simply put the extended description on a second line,
and set the textbox's CanGrow and CanShrink properties to True. The
entire textbox will vanish if there is no description.

John W. Vinson[MVP]
 
Back
Top