Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Getting Started > Populate memo f...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 16859 of 17534
Post > Topic >>

Populate memo field with check box

by "Steve Goodrich" <stevegoodrich@[EMAIL PROTECTED] > Aug 5, 2008 at 11:28 AM

I use up to 6 check boxes to populate the same memo field
When I click the first check box "Ph1" the text is entered into the memo 
field on a new line "PATROL OF PHASE 1" - this works great for my needs.

I have 6 of these check boxes Ph1 to Ph6

If I check the wrong box I simply uncheck it but the text still remains in

the memo field

MY QUESTION

How do I delete just the text for the relevant check box if I uncheck It, 
without deleting the other entries in the same memo field?

The code I am using is as follows.The memo field is called "Incident"

Private Sub Ph1_Click()
If Me.Ph1 = True Then
Me.Incident = Me.Incident & vbCrLf & "PATROL OF PHASE 1"
End If
End Sub

Any help would be appreciated

Steve
 




 8 Posts in Topic:
Populate memo field with check box
"Steve Goodrich"  2008-08-05 11:28:04 
Re: Populate memo field with check box
"Linq Adams via Acce  2008-08-05 12:29:12 
Re: Populate memo field with check box
"Steve Goodrich"  2008-08-05 12:45:40 
Re: Populate memo field with check box
John Spencer <spencer@  2008-08-05 09:59:51 
RE: Populate memo field with check box
=?Utf-8?B?RGVubmlz?= <  2008-08-05 05:41:01 
Re: Populate memo field with check box
fredg <fgutkind@[EMAIL  2008-08-05 08:11:47 
Re: Populate memo field with check box
"Steve Goodrich"  2008-08-05 17:21:40 
Re: Populate memo field with check box
fredg <fgutkind@[EMAIL  2008-08-05 13:17:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 17:02:53 CST 2008.