Having a problem with a linked view not showing all the data in a varchar(4004) field
No the row isn't over 8000 total, thanks for the help.
Randall Vollen
National City Bank Corp.
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!
Problem with View field showing as text 255 instead of Memo 1
- Thread starter hwkranger
- Start date
-
1
- #2
Randall
No body got back to you on this. Probably way too late, but
See suggestion #8 in...
No body got back to you on this. Probably way too late, but
See suggestion #8 in...
- Thread starter
- #3
Willir,
Thank you for getting back to me. I didn't think I had to cast from a view that pulled from a table. I'm going to try it. My problem isn't a conversion problem, but rather a problem with access truncating due to it thinking that a varchar(4004) field is 255.
Randall Vollen
National City Bank Corp.
Thank you for getting back to me. I didn't think I had to cast from a view that pulled from a table. I'm going to try it. My problem isn't a conversion problem, but rather a problem with access truncating due to it thinking that a varchar(4004) field is 255.
Randall Vollen
National City Bank Corp.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
