none
Are there any issues with copying data from memo fields to text fields? RRS feed

  • Question

  • I have inherited some Access databases. The previous developer has queries that append date from one table with memo fields to corresponding fields in another table that have text fields. I have noticed data is lost when the queries are run. I am wondering if copying data from a memo field to a text field could be part of the problem.
    Thursday, September 10, 2015 4:46 PM

Answers

  • Yes.  A text field stores up to 255 characters, a memo field can store much more.  Anything copied from memo to text field will be truncated to 255 characters or whatever the text field is set to for its limit.


    • Edited by RunningManHD Thursday, September 10, 2015 4:55 PM
    • Proposed as answer by André Santo Thursday, September 10, 2015 5:44 PM
    • Marked as answer by TWIKLE Thursday, September 10, 2015 10:54 PM
    Thursday, September 10, 2015 4:53 PM