Editing a concatenated field

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

Guest

I have a form with a series of checkboxes which create a concatenated string
which is displayed in a new field. This new field is a "calculated field" and
is not editable (read-only) once created. How do I collect this string and
place it in a new memo field which then allows further user editing? It seems
like a "cut and paste" situation, but is there code to make that happen
automatically?

Thanks in advance,
MEOlsen
 
It generally isn't necessary to redundantly store the same data. If you
want to edit the concatenated string, why not just modify the checkboxes?

One issue with saving the concatenated string into another field is
precisely because you could edit it, at which point it would no longer match
the checkboxes!

Good luck

Jeff Boyce
<Access MVP>
 
Ordinarily, you would be right, but in this case the checkboxes are to create
"commonly used phrases" in a report, but it isn't practical to use them for
each word in the field. I really need to "redundantly" store the phrases and
then have the ability to tweak the finished string.

Is this possible?

MEOlsen
 
Ordinarily, you would be right, but in this case the checkboxes are to create
"commonly used phrases" in a report, but it isn't practical to use them for
each word in the field. I really need to "redundantly" store the phrases and
then have the ability to tweak the finished string.

Is this possible?
Click to expand...

Yeah - what you'ld do is use the AfterUpdate event of the checkbox to
populate the memo field:

Public Sub chkPhrase3_AfterUpdate()
If Me!chkPhrase3 Then ' did they check it?
Me!txtMemo = Me!txtMemo & <the looked up phrase>
End If
End Sub

John W. Vinson[MVP]
 
Thanks much, John, that works fine.

MEOlsen

John Vinson said:
Yeah - what you'ld do is use the AfterUpdate event of the checkbox to
populate the memo field:

Public Sub chkPhrase3_AfterUpdate()
If Me!chkPhrase3 Then ' did they check it?
Me!txtMemo = Me!txtMemo & <the looked up phrase>
End If
End Sub

John W. Vinson[MVP]
Click to expand...
 
Back
Top