Can I format a Linked Table

Hi Guys

Here is the scenario.
I have linked a table from a SQL database to MS Access.
There is a text field in that SQL database table which
carries more than 255 characters. However the link table
does not seem to have full text string. Is there a way to
manipulated the Access linked table to display the full
text.

Thanks guys

best regards

Sarah

Hi there

Sounds to me like when the link table was created, Access
automatically assigned a Text data type to the text field.
The Text data type is limited to 255 characters. In the
table design, see if it will let you change the data type
to Memo. This will hold far more characters. Then use
Linked Table Manager to refresh the data.

Don't know if you can change data types in a linked table
but it's worth a try!

Cheers

David

-----Original Message-----
Hi Guys

Here is the scenario.
I have linked a table from a SQL database to MS Access.
There is a text field in that SQL database table which
carries more than 255 characters. However the link table
does not seem to have full text string. Is there a way to
manipulated the Access linked table to display the full
text.

Thanks guys

best regards

Sarah
.

Sarah

Go to Google.com and navigate through to the msaccess Group. Type in "Note
Field in Access" as a search criterion (use the quotes).

The discussion on that thread offers additional ideas on why this may be
happening.

--
Good luck

Jeff Boyce
Access MVP