<div>
This should let you know if Len is 250 or greater<br />
<br />
Select Import_Excel.Description, IIF(Len(Import_Excel.Descr<wbr />iption)&gt;25<wbr />0,&quot;Near Max&quot;,&quot;OK For now&quot;) As Result<br />
FROM Import_Excel
</div>


This should let you know if Len is 250 or greater

Select Import_Excel.Description, IIF(Len(Import_Excel.Description)>250,"Near Max","OK For now") As Result
FROM Import_Excel

<div>
<blockquote>
is <b>near</b> its maximum 255 characters?
</blockquote>
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
How could I determine if the field [Description] is near its maximum 255 characters?<br />
This would be within a query. <br />
<br />
example here:<br />
SELECT Import_Excel.Description<br />
FROM Import_Excel;<br />
<br />
thank you
</div>
</div>


Experts,

How could I determine if the field [Description] is near its maximum 255 characters?
This would be within a query. 

example here:
SELECT Import_Excel.Description
FROM Import_Excel;

thank you

Equal to 255 characters

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.