×
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

limit report output to last 200 char. in memo field

limit report output to last 200 char. in memo field

limit report output to last 200 char. in memo field

(OP)
hello,

We run regular reports that contain case notes and client histories from memo fields in the database.

In my reports some of the memo fields are longer than the unabridged OED.

Is there a way to limit what shows in the report to the last so many lines or certain number of characters?

I really only need the most recent case history from the memo field, and I hope there is a way to do this.

Thanks all....

Ray

RE: limit report output to last 200 char. in memo field

Right([YouMemoField, 200)



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

RE: limit report output to last 200 char. in memo field

(OP)
Thanks for the input Michael, unfortunately it does not seem to work as advertised.  It works ok on text fields and numbers, but it won't work for me on the memo field - not sure why. I've likely done something wrong, but cant see how in such a simple parameter.

Are there other needs that must be met in the defining of the field?

What I get is just one letter or number then nothing more, it doesn't seem to like 2 digit numbers as a value.  I have tried it on the other fields with just numbers, and it works ok.

Strange.....

Ray

RE: limit report output to last 200 char. in memo field

(OP)
Ok, mea culpa, big loser here, :)

I was trying to use the parameter as in the property setting of a field ( sorta works ) when I should have been using it as a solo expression in the query.

It does now work, but, it only goes back as far as a word wrap or carriage return or blank line in the memo field.

I have a forced blank line between entries in the memo field that is inserted on update - is there a work around?

thanks for your patience.....

Ray

RE: limit report output to last 200 char. in memo field

(OP)
It all works now.  Many thanks

Discovered people had been putting in there own carriage returns, when they didn't need to.  the field auto wraps but when people start hitting enter a bunch of times, or they use the space bar to position the cursor, (?) , it messes things up.

Oh well, it works now

( Users - Bah! )

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