超过255个字符的长文本字段被截断 [英] Long Text Field over 255 Characters gets truncated

问题描述

不确定为什么返回结果后我的查询中的字段会被截断.该值存储在该字段中，但是会因访问性能"而被截断.我已经审查了多个论坛和SO帖子，但无济于事.

Not sure why my field in my query is getting truncated upon the return of the result. The value is being stored in the field, but gets truncated by access to help with "performance". I have reviewed multiple forums and SO posts to no avail.

链接中列出的问题不适用，

Problems listed at link do not apply, Aggregation, Uniqueness, Union, Format Property, Row Source

我的查询出了什么问题? 客户"表中的说明"字段将被截断.

What is wrong with my query? Instructions field in the Customer table is the one that is getting truncated.

这是访问权限生成的原始查询:

Here is the raw query generated by access:

SELECT Task.ID, Task.TaskID, Task.TaskName, Task.TypeID, TaskType.TaskTypeName, Task.CustomerID, Customer.CustomerName, Customer.OnHold, Customer.Blacklisted, Customer.CustomerEngagementRecieved, Customer.AutoEmail, Customer.SpecialInstructions, Customer.Instructions, Task.QuoteRequired, Task.PriorityID, Priority.Priority, Task.Min, Task.Max, Task.Projected, Task.DeadlineDate, Task.ResourceID, Resource.ResourceName, Resource.Email, Resource.Extension, Task.Description, Task.StatusID, Status.Status, Task.DeveloperLog, Task.TaskPOCID, POC.Phone, POC.Email, Task.OtherPOC, Task.OtherPOCPhone, Task.OtherPOCEmail, Task.FolderPath, Task.StopBilling, Task.Premium, Task.EntryDate, Task.CompleteDate, Task.AssignedBy, Task.SettingsID, Settings.AutoEmail
FROM TaskType 
    INNER JOIN (Status 
    INNER JOIN (Settings 
    INNER JOIN (Resource 
    INNER JOIN (Priority 
    INNER JOIN (Customer 
    INNER JOIN (Task 
    INNER JOIN POC ON Task.TaskPOCID = POC.POCID) 
        ON Customer.CustID = Task.CustomerID) 
        ON Priority.PriorityID = Task.PriorityID) 
        ON Resource.ResourceID = Task.ResourceID) 
        ON Settings.SettingsID = Task.SettingsID) 
        ON Status.StatusID = Task.StatusID) 
        ON TaskType.TTID = Task.TypeID;

`

推荐答案

所以从它的声音来看，无论设置如何，Access有时总是会截断该字段.通过使用

So from the sounds of it, Access just sometimes will ALWAYS truncate the field no matter what the settings. There is a way to force access to show the entire field though, by using the DLOOKUP() function instead of using a Control Source.

以下是我当前问题的答案，以供参考， =DLOOKUP("Instructions", "Customer", "CustID=" & [CustomerID])

Here is the Answer to my current Issue for reference, =DLOOKUP("Instructions", "Customer", "CustID=" & [CustomerID])

这篇关于超过255个字符的长文本字段被截断的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！