limit.mdb

limit.xls

<div>
Interesting. &nbsp; At least I know there is a work around. &nbsp;Will test it out. &nbsp; Thank you for the help Nick.
</div>


Interesting.   At least I know there is a work around.  Will test it out.   Thank you for the help Nick.

<div>
And thank you!<br />
It turns out that the point you awarded put me over 1 million.<br />
That's not something that happens everyday :)<br />
<br />
Nick67
</div>


And thank you!
It turns out that the point you awarded put me over 1 million.
That's not something that happens everyday :)

Nick67

<div>
<div class="content wysiwyg-content">
Experts, it seems if you link to an excel file, the field in the report is limited to a certain character limit. &nbsp;I am not sure if this is fixable unless the excel file is imported, which is not what I want to do. &nbsp;Since the excel file is linked I can not change the properties like I can in an access table. <br />
<br />
Am I stuck with the field character limit Access uses?<br />
<br />
thank you
</div>
</div>


Experts, it seems if you link to an excel file, the field in the report is limited to a certain character limit.  I am not sure if this is fixable unless the excel file is imported, which is not what I want to do.  Since the excel file is linked I can not change the properties like I can in an access table. 

Am I stuck with the field character limit Access uses?

thank you

Linked Excel and field character limit

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.