Why not restrict the number of characters in your query? Like this:
ConcatenateField:left(OtherField1 + OtherField2 + OtherField3),30)
John
--
John V. Ruff The Eternal Optimist :-)
Commit to the Lord whatever you do,
and your plans will succeed. Proverbs 16:3
-------------- Original message --------------
From: "access_kri" <[EMAIL PROTECTED]>
Dear All,
I need the groups help urgently. I am stuck and cannot find a
way. Please help.
I have a text box in a form that is bound to a query field.
This text box concatenates text from other fields of the query. I want
to restrict the length of this textbox to 30 characters. Pl. guide me
how to do it. Reason: I am pasting the result of the textbox in a
software field, where there it can accept only 30 characters. I would
like a message box warning if the length exceeds 30 before saving the
record.
Thanks and Regards,
Kumar
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
