?
Solved

Extract Portions of text box Information and insert into another textbox

Posted on 2013-05-10
4
Medium Priority
?
446 Views
Last Modified: 2013-05-10
I need to assign the value of a text box "txtheading" from information from another field named "Remarks" the value needs all text up to the first semicolon example:

Dim header as string
header= remarks.first line up to semicolon
txtheading=header

Open in new window



Or
txtheading.value= header= remarks.first line up to semicolon

whichever works better...

The information should appear exactly as it appears up to the semicolon including spaces and case
0
Comment
Question by:mickeyshelley1
  • 2
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39155428
Dim header as string
header= Split("" & Remarks, ";")(0)
txtheading=header

Open in new window

0
 

Author Comment

by:mickeyshelley1
ID: 39155433
Trying it
0
 

Author Closing Comment

by:mickeyshelley1
ID: 39155454
Thanks AGAIN : mbizup that works great!!! and thanks for responding so quickly
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39155497
Glad to help :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question