Re: using formulas in text fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Thu, 14 Dec 2006 21:07:45 GMT, everymn@xxxxxxxxx wrote:

Hi,

I have a large memo field from which I'd like to display only the last
5 characters. I thought the way to do this would be to set the
control source to this:

=Right$([f5],5) or this
=Right([f5],5)

but in either even it's giving me #Error. If I just set it to [f5]
then the full text displays so the source is good but evidently I'm
phrasing it wrong. The same thing is happening in both memo and text
fields. Could someone tell me what the correct syntax is?

Thank You

Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: How to Limit Memo to 1500 Characters
    ... Something like "Please enter less than 1500 characters." ... In Design view, select the memo field. ... Now if you wish to use a Validation rule you can. ... Please respond only to this newsgroup. ...
    (microsoft.public.access.forms)
  • Re: modifying a memo field programmatically
    ... modify the content of a memo field by searching for a "number followed by a ... character can be added in a memo field in access or not. ... newsgroup, such as ...
    (microsoft.public.office.developer.vba)
  • Re: Textbox character limit
    ... but the textbox will only allow 127 characters to be entered ... Size property was set to 255 characters, not the memo field. ... Please only reply to this newsgroup. ... I do not reply to personal email. ...
    (microsoft.public.access.forms)
  • Re: Memo field truncated in mailmerge
    ... > I have a mailmerge with a memo field that seems to be truncated at about 255 ... > merge data to it is truncating the field. ... Do you know which data connection method you're using to link the mail merge to ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)
  • Re: using unbounded text box for memo field - cutting off characters at 255
    ... Follow your post in the "forms" newsgroup and ... Rick B ... > I'm using an unbounded text box for a memo field on form. ... Prev by Date: ...
    (microsoft.public.access.formscoding)