In my report, why does ">" format make memo field lose data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IN MY REPORT, I SET THE FORMAT PROPERTY TO:

AND WHEN I RAN THE REPORT THE FORMAT WAS ALL UPPERCASE, AS I HAD WANTED IT
TO BE, BUTHALF OF MY DATA INTHE FIELD WOULD NOT DISPLAY...! NO GOOD! WHAT DO
I DO...I'VE TRIED FORMATTING THE DATA IN THE TABLE AND IN THE QUERY TO
UPPERCASE INSTEAD...BUT I HAVE FOUND THAT WHEN THE DATA DISPLAYS IN THE
REPORT IT WON'T BE UPPERCASE UNLESS I SET THE PROPERTY DIRECTLY ON THE REPORT
ITSELF...

AAARGH! HELP ME!!!
 
Any value in the format property will truncate your text to 255 characters.
I'm not sure why you want to uppercase the text since it is consider
shouting in news groups (hint).

You might be able to use the UCase() function and remove the format
property:
=UCase([Your Memo Field])
 
That's correct. If Access is asked to convert the case of the text box, it
truncates the value after 255 characters.

To work around the problem:
1. Change the Name of your text box so it is not the same as your field
name. For example, name it Text99. (Name is on the Other tab of the
Properties box.)

3. Change the Control Source of your text box to:
=StrConv([Field1],1)
substituting your field name for Field1.

BTW, we know you love upper case, but we don't enjoy you shouting at us
here.
 
ST8 said:
IN MY REPORT, I SET THE FORMAT PROPERTY TO: >

AND WHEN I RAN THE REPORT THE FORMAT WAS ALL UPPERCASE, AS I HAD WANTED IT
TO BE, BUTHALF OF MY DATA INTHE FIELD WOULD NOT DISPLAY...! NO GOOD! WHAT DO
I DO...I'VE TRIED FORMATTING THE DATA IN THE TABLE AND IN THE QUERY TO
UPPERCASE INSTEAD...BUT I HAVE FOUND THAT WHEN THE DATA DISPLAYS IN THE
REPORT IT WON'T BE UPPERCASE UNLESS I SET THE PROPERTY DIRECTLY ON THE REPORT
ITSELF...


Specifying anything for the format of a long memo value will
truncate the memo at 255 characters. Try removing the
format and using a control source expression instead:
=UCase(fieldname)

P.S. you may like reading all upper case text, but it gives
me a headache. Please use you shift key appropriately.
 
Back
Top