Select a string more than 255 characters

[seaport]

I am creating a query as &quot;select comments() as MyComments from tblgroups&quot;.<br>Comments() is a public function and returns a string with the length over 255.<br>However, when I preview the query in the datasheet mode, I find out in the column &quot;MyComments&quot;, only first 255 charactes are displayed. It seems that Access takes this field as TEXT instead of MEMO.<br>I try to find a way to define this field &quot;MyComments&quot; as MEMO, but I can not find it.<br><br>Can anyone help me out?<br><br>Thanks in advance.<br>

 

[DougP]

Well I guess you looked at the Design view of your table???<br>Memo is right under text<br>Or am I missing something in your question?<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[seaport]

I just figured out this problem.<br><br>Actually, I used &quot;Distinct&quot; keyword in the query. I believe it is this keyword that prevents Access take &quot;MyComments&quot; as MEMO.<br><br>