×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Return first line of textbox

Return first line of textbox

Return first line of textbox

(OP)
Hello,

I have a block of text and just want to show the first line in a query. Im struggleing to see how to do this.

Any help would be much appreciated

Thank you
Mark

RE: Return first line of textbox

First 'line' is a char sequence that end with chr(10) or chr(13)
Then left$(block_of_text,instr(block_of_text,chr(10)) i think that return a 'first line' of the block

RE: Return first line of textbox

>First 'line' is a char sequence that end with chr(10) or chr(13)

Not necessarily. Depends on the source of the block of text. Might be a multiline textbox with wordwrap ...

RE: Return first line of textbox

Mark needs to provide more information/examples.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: Return first line of textbox

(OP)
Thank you kindly - sorry for my delayed resposnse, I have been a little unwell. Many thanks - Mark

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close