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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Run time error 20515
- Thread starter Riihela
- Start date
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
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
- Thread starter
- #3
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question