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!
  • Students Click Here

*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

Run time error 20515

Run time error 20515

Run time error 20515

I receive run time error 20515 : "A memo field cannot be used in a formula" after changing the field data type in Access 2000 database from text to memo. Now, when changing back to text data type in Access, Crystal Reports (version 4.6 delivered with VB 6.0)does not recognize the change - still receiving the same error message. How could I solve this problem?   

RE: Run time error 20515

Have you verify the database after your change?

Database / verify database  (in CR 8.5, anyway)

Sometime it needs that to refresh.  It will say : the database "ado" (or else) have changed, do you want to fix the report...

It's what i need to do in CR 8.5

RE: Run time error 20515

Thank you for your reply, melginger. The problem was that the maximum length of a text string in CR seems to be 127. In Access 2000 the limit is 255. So, if I have the length of a text field e.g. 250 in Access, CR thinks it is a memo field.

However, I can cheat CR by not allowing it to verify the database after increasing the size of the text field in Access. Now I can use 255 characters and yet use this field in formula:)

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