using formulas in text fields

  • Thread starter Thread starter everymn
  • Start date Start date
E

everymn

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
 
Make sure that your control is not named f5. Access will get confused on
what is should do if you have a field and a control with the same name and
then attempt to reference that name in an expression in a control. Try
making the control's name something like txtF5.
 
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
Click to expand...

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.
 
Back
Top