memo field in form does not display everything

[mrrayj60]

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take the data from tableA and place in my field in tableB. I'm lost here and need some help, thanks. Ray oh its replaced from a query column
Me.txtdecsription = Me.cbo69.Column(2)

 

[Scooterbug]

A memo field's max size is 255 characters, which is why that's all it's displaying.

The question is, why are you using a memo field to shuffle data around? You should be using an Append query.

 

[boblarson]

A memo field's max size is 255 characters, which is why that's all it's displaying.

Oops, error, error

A memo field's size is 65,536 characters max, which is considerably more than 255. Read this.

 

[Scooterbug]

Oops, error, error

A memo field's size is 65,536 characters max, which is considerably more than 255. Read this.

Ack! I'm off my game today....typos, misinformation....starting to think it's a Monday!

 

[boblarson]

Ack! I'm off my game today....typos, misinformation....starting to think it's a Monday!

I was doing that last week. You must have caught it from me.

 

[missinglinq]

Also of concern to me is:

These are both table fields and are memo fields. I use a replace command on the form to take the data from tableA and place in my field in tableB.

I can only take this to mean that you're trying to store the same data (and large amounts of it, at that!) in multiple tables, which is a gross violation of Normalization.

 

[mrrayj60]

Oops, error, error

A memo field's size is 65,536 characters max, which is considerably more than 255. Read this.

Hi Bob, I read thru that and I've got no format issues anywhere they ask. I am trying to input from a query so I'm guessing the only work around is doing that append it to another table and then import it, is that your solution too? It seems like alot to do alittle. To answer the questions why here and there, its a complaint and I need to quote the rule and would rather have an exact snapshot of the rule in the record, people are getting fined. kind of cya, this is the way it was on this date kinda thing.

 

[boblarson]

No, try using two queries.

First one has only the fields without the memo field.

Second one has the first query in it as well as the original table, linked by its key and then the memo added.

 

[mrrayj60]

No, try using two queries.

First one has only the fields without the memo field.

Second one has the first query in it as well as the original table, linked by its key and then the memo added.

Bob,
qryrules is the 1st without the memo field, description, This is qryrules2 adding the field from the table, rules. same result, see anything or did I read your note wrong? Thanks. Ray

SELECT qryrules.VIOLATIONID, qryrules.RULECATEGORY, RULES.DESCRIPTION, qryrules.VIOLATIONOF, qryrules.QUOTEDARTICLE
FROM qryrules INNER JOIN RULES ON qryrules.VIOLATIONID = RULES.VIOLATIONID
ORDER BY qryrules.RULECATEGORY;

 

[boblarson]

Bob,
qryrules is the 1st without the memo field, description, This is qryrules2 adding the field from the table, rules. same result, see anything or did I read your note wrong? Thanks. Ray

SELECT qryrules.VIOLATIONID, qryrules.RULECATEGORY, RULES.DESCRIPTION, qryrules.VIOLATIONOF, qryrules.QUOTEDARTICLE
FROM qryrules INNER JOIN RULES ON qryrules.VIOLATIONID = RULES.VIOLATIONID
ORDER BY qryrules.RULECATEGORY;

Make sure you don't have the ORDER BY on this last query. Put it in the first (qryrules).

 

[mrrayj60]

Make sure you don't have the ORDER BY on this last query. Put it in the first (qryrules).

corrected, same result 255 characters exactly...Ray

qryrules
SELECT RULES.VIOLATIONID, RULES.RULECATEGORY, RULES.VIOLATIONOF, RULES.QUOTEDARTICLE
FROM RULES
ORDER BY RULES.RULECATEGORY;

qryrules2
SELECT qryrules.VIOLATIONID, qryrules.RULECATEGORY, qryrules.VIOLATIONOF, qryrules.QUOTEDARTICLE, RULES.DESCRIPTION
FROM qryrules INNER JOIN RULES ON qryrules.VIOLATIONID = RULES.VIOLATIONID;

 

[mrrayj60]

The qry is getting all the text needed just not adding it, I added the word arnold to tell me where I was in text count.
qryrules2
DESCRIPTIONAll pets must be physically leashed when outside of the home or fence or enclosure and shall not be permitted to run loose. No more than two pets, not including any pets which live and are maintained within an enclosed cage, are permitted on any lot. Arnold No exterior modification to a dwelling or improvement upon a lot shall be started until Architectural Control Committee approvals have been obtained.No exterior modification to a dwelling or improvement upon a lot shall be started until Architectural Control Committee approvals have been obtained.

 

[boblarson]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

 

[mrrayj60]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take the data from tableA and place in my field in tableB. I'm lost here and need some help, thanks. Ray oh its replaced from a query column
Me.txtdescription = Me.cbo69.Column(2)

 

[mrrayj60]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take the data from tableA and place in my field in tableB. I'm lost here and need some help, thanks. Ray oh its replaced from a query column
Me.txtdescription = Me.cbo69.Column(2)

 

[mrrayj60]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

Hey Bob,
Is it me or is this server so slow this week. So do you have any other ideas on how to transfer the memo field info to complaint file via a query/form? I told the boss the problem and he kinda looked at me, like what? lol, I gave them access to copy and paste the rule for the time being. Thanks, Ray

 

[mrrayj60]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

Hey Bob,
So I told the boss my problem and he looked at me with a strange look and said what? lol...I enabled the field so they can cut and paste for the time being. Do you think its possbile to get the memo to memo via a qry/form? Thanks, Ray, is it me our is the site slow this week, I thought I just posted this...

 

[mrrayj60]

What are you saying? You are trying to update a record through that query? I thought you only needed to get the information.

Hi bob,
Do you know if its possible to append the memo field to my other table? I can't seem to find an clear solutions, but I'll keep hunting. If you have nay other thoughts please let me know. Thanks for your help.
Ray

 

[boblarson]

Maybe I'm being dense here, but I am wondering why you would be trying to save the same data from a memo field in two different tables. And, perhaps instead some other design would be better. So, sorry for asking this but can you explain (with a real life type of example) what is in these memo fields and why you would be putting the data into two separate places?

 

[mrrayj60]

Hi,
I am adding a complaint to a residents file and I want to quote the rule he broke. That comes from rules. I want to append it to the actual complaint to make sure its a snapshot of the exact wording as it was on that day. The homeowners association has a history of changing rules wording during the year so If I'm linked and the rule chages, it may no longer have applied. So I felt a snapshot of the rule locked into the complaint was the best route. Your thoughts are appreciated too. I'm making alot of stuff including a new designed residents form and I'll be posting a question about tab forms, I really like these type from a user point.

Thanks again, Ray