Query field length???

  • Thread starter Thread starter Rohn
  • Start date Start date
R

Rohn

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255 characters. I changed it to Memo, expecting to have much more room to store data in that field. Well, the table works like it should, but the query and the related Reports still act like there is a limit to the field length of 255 characters.... WHAT GIVES??????

Any insight would be appreciated!
 
Rohn

As for the Reports, they "inherited" the field as it was THEN defined.
Updating your table definition doesn't automatically update the objects
depending on it.

I'm not sure on the query, but just for safety, you could delete the field
from your query grid and re-select it.

You'll want to take a look at your Forms, too. Any of them with the former
field have the former definition.
 
POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone can
spot the exact problem for you.
 
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
 
So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255 characters. I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
 
it did work!

I'm sure, its not the right way to get it fixed but it was the only way I
knew!
----------
Rohn Everson

So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255
Click to expand...
characters.
I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
 
I can only guess that the original query had a format set in the query grid that
was causing the problem. It is always possible that the specific query had some
corruption in it. - Guess we will never know.

Glad it got fixed.
it did work!

I'm sure, its not the right way to get it fixed but it was the only way I
knew!
----------
Rohn Everson

So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255
Click to expand...
characters.
I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top