Hello and Good Morning,
I am a new member to the forum and was hoping someone could please help me with a problem.
I have a check box on a form and I would like that when the checkbox is "checked" or "true" that some text is added to a text box (I am using the textbox as a data source for a mail merge after I export it using excel).
I have, after various efforts now got the text I want to be added to the textbox being added; (without deleting anything else that is in the textbox).
What I want is so that if the text box is unticked (or False), then no text is added to the text box or any text it has already added is removed (and the original text in the text box, if any, remains).
Top summarise it is if true add this to the text box, if False add nothing to the text box (or remove what you have already added).
what I have got so far is as below.
Private Sub Bencalculator_AfterUpdate()
If Me.Bencalculator = True Then
Me.Benefit_Type = Me.Benefit_Type & "Benefit Search Calculator"
End If
End Sub
NB;
Bencalculator is the checkbox
Benefit_Type is the textbox
"Benefit Search Calculator" is the text to be added/ removed to the textbox (without deleting any other text).
I have search on the internet but can not seem to find the Else or Then action or description I am looking for.
I thank you in anticipation of any help you can offer,
thank you.