If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Can I format a Linked Table
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 . |
#3
|
|||
|
|||
Can I format a Linked Table
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 |
Thread Tools | |
Display Modes | |
|
|