Memo Field

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

Guest

How can I setup a default in a memo field. Here is what I am trying to do

When the user opens a memo field, automatically it would display

Cause

Complaint

Correction

Now I know that this isn't the prefered method of doing this, but this is what I have been asked to do
What else I would like to do is the cursor start after "Cause; " , then with insert off, be able to type the next 70 space
without causing "Complaint or correction" to move down the page. Then move my cursor after "Complaint: " and do the same thing, etc

Can this be done? I figured that if the 70 spaces were there and you could replace them with text, it should work. I can make it work like this in a text file but can I do this in a memo field

Thank you for any comment

RK
 
Hi RK,

These three different things should be in three separate fields - in
which case the problem wouldn't arise. It's easy to concatenate the
fields - with or without additional newlines - when needed.
 
RK said:
How can I setup a default in a memo field. Here is what I am trying to do.

When the user opens a memo field, automatically it would display:


Cause:

Complaint:

Correction:


Now I know that this isn't the prefered method of doing this, but this is what I have been asked to do.
What else I would like to do is the cursor start after "Cause; " , then with insert off, be able to type the next 70 spaces
without causing "Complaint or correction" to move down the page. Then move my cursor after "Complaint: " and do the same thing, etc.

Can this be done? I figured that if the 70 spaces were there and you could replace them with text, it should work. I can make it work like this in a text file but can I do this in a memo field?
Click to expand...


One of the fundamental rules of relational databases is that
each field should contain only a single value. There may be
a time when you want to analyze this data by the contents
of, for example, the Correction without being confused by
what's in the rest of this memo. Try to convince the powers
that be that it would be better to use three separate memo
fields for this data.

If you are forced to do it in one memo field, then you can
get what they want bby setting the text box's DefaulValue
property to an expression:

="Cause:" & Chr(13) & Chr(10) & Chr(13) & Chr(10) &
"Complaint:" & Chr(13) & Chr(10) & Chr(13) & Chr(10) &
"Correction:"
 
Yes, I would like to have 3 separate fields, but they don't want to do that at this time (and will be later

Marsh
If I do it the way you propose, when I type after say the "Cause: ", as I type would the others move farther down

Thanks R
 
Yes, I would like to have 3 separate fields, but they don't want to do that at this time (and will be later)

Marsh,
If I do it the way you propose, when I type after say the "Cause: ", as I type would the others move farther down?

Thanks RK
Click to expand...

RK,
You're doing it incorrectly and will be asking how to undo it soon
enough.

For heavens sakes, just try it... you would have had your answer
already!!!!
 
Back
Top