Solved

Extract Portions of text box Information and insert into another textbox

Posted on 2013-05-10
4
379 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 500 total points
Comment Utility
Dim header as string
header= Split("" & Remarks, ";")(0)
txtheading=header

Open in new window

0
 

Author Comment

by:mickeyshelley1
Comment Utility
Trying it
0
 

Author Closing Comment

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

Expert Comment

by:mbizup
Comment Utility
Glad to help :)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now