Possible to enter/display separate info in one textbox on form?

[blanca488]

i am creating a data entry form and have yes or no checkboxes inside option groups for questions 1-5 for the user to select from.<br>
<br>
if a checkbox is marked yes, i'd like the cursor to move over to a text box so then the user has the ability to add a comment. <br>
<br>
but, i was wondering...if there was a way for the comments to be entered in one big text box, but still considered separate entities on the table. ...that when each question is answered yes, that the cursor could just pop over to the text box and bump down one line after the last comment (if any) that was entered.<br>
<br>
am i making sense?<br>
<br>
thanks,<br>
melissa<br>
<A HREF="mailto:blanca488@hotmail.com">blanca488@hotmail.com</A>

 

[DougP]

Yes you are making sense<br>
But how much VBA code do you want to write and or how good are you at VBA coding.<br>
Also the main reason not to lump a lot of information in one area is difficulty finding specific's later.<br>
Example:<br>
You would not want to put a persons whole mailing address in one field called &quot;Address&quot; if later you wanted to query by last name and state or zip.<br>
<br>
But if you must...<br>
Look at these functions <br>
Instr, Mid, Len, to find the text <br>
Then you need something to position the cursor at the end or create a new line.<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

What is the purpose of lumping them together? You may be able to enter them separately and <i>then</i> display them together instead. For instance, you could have a text box after each checkbox, have code in the AfterUpdate event of the checkbox SetFocus to the appropriate textbox only with a &quot;yes&quot; answer. And in the onUpdate even of the textbox you could concatenate all the existing comments together for display.

 

[blanca488]

thanks for the help. <br>
<br>
i was later thinking along the idea that you brought up, elizabeth, and i am going to try that approach.<br>
<br>
the only reason why i wanted to try to lump them together was because the vp suggested it that way. and i'm not the keenest access programmer yet, so i really *wasn't positive* it could be done that way when he first suggested it. <br>
<br>
thanks again.<br>
<br>
melissa

 

[elizabeth]

It's nice to make the VPs happy I usually try to educate them on how things are commonly handled before I begin the design process, so they'll make suggestions that I can accomodate more easily. Then it's nicer for me too