Click a button and send a text phrase to a memo field

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

Guest

I have a form that I write quotations on. It all works well. However, there is one section which is vary variable, lots of data or none at all. What I want is to press a button or whatever is suitable, that will send a lengthy text phrase to a memo field. I need it to be an end user driven thing i.e. macro or button etc as it is not always required

Any ideas

TIA

Perry Ker
 
Why don't you just have a memo field on your form and enter the text there?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


PMK said:
I have a form that I write quotations on. It all works well. However, there
Click to expand...
is one section which is vary variable, lots of data or none at all. What I want
is to press a button or whatever is suitable, that will send a lengthy text
phrase to a memo field. I need it to be an end user driven thing i.e. macro or
button etc as it is not always required.
 
The memo field is already on the form

My requirement is that for certain quotations I have a standard charge and phrase which encompasses a lot of text in the way it describes what is on offer. What I want is to just have this automatically entered when I click something, instead of having to copy and paste it from previous quotes

I hope that has explained what I am after with slightly more clarity than previousl

Perry Ker
 
My suggestion is to have a table of standard quotations like:
TblStandardQuotations
StandardQuotationID
Phrase
Charge

You then need an unbound combobox on your form whose rowsource is this table.
You will use the combobox to select the quotation.

Put the following code in the AfterUpdate event of the combobox:
Me!NameOfMemoField = Me!NameOfComboBox.Column(1)
Me!NameOfChargeField = Me!NameOfComboBox.Column(2)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


PMK said:
The memo field is already on the form.

My requirement is that for certain quotations I have a standard charge and
Click to expand...
phrase which encompasses a lot of text in the way it describes what is on offer.
What I want is to just have this automatically entered when I click something,
instead of having to copy and paste it from previous quotes.
 
PMK said:
The memo field is already on the form.

My requirement is that for certain quotations I have a standard charge and phrase which encompasses a lot of text in the way it describes what is on offer. What I want is to just have this automatically entered when I click something, instead of having to copy and paste it from previous quotes.

I hope that has explained what I am after with slightly more clarity than previously

Perry Kerr
Click to expand...

Would I be right in thinking that this is standard boilerplate text that
either does or doesn't appear in the final printed quote for the customer?

If that's the case, why not simply have a yes/no field on the form for
"Stamdard text included?" and use that to make the standard text
visible or invisible in the printed report (or form)?

Steve
 
Back
Top