Shrink fields in a Report

[Kovacs]

In order to shrink blank fields with labels, I converted the labels in textboxes and used as control source the following code: ="Title: "+[Title] (for instance).
This worked so far, but also generated two hateful issues I wasn't able to fix:

1. The code won't work if the related fields are numeric, date or currency fields. It seems to work only with simple text fields.

2. In one case, Access automatically performs an unwanted correction to the control source, changing only the part within the brakets: ="Properlabel: "+[Unwanted correction], so the code won't work. It keeps changing the proper text in [Description] (the text I want, in my language, is very similar to "Description", so Access is performing an autocorrect, I guess). I tried to disable any kind of autocorrect and name autocorrect with no result. This is driving me crazy.

In both cases I can't simply use a "text" as control source, since it will have no connection to the field, and the textbox won't shrink if the field is blank (right?)

I'm sure the solution is simple and I'm missing something..
Any advice will be greatly appreciated...

 

[Kovacs]

Ok I found a better solution: =IIf(IsNull([FieldName]);Null;"Label:")
This works with numeric, data and currency fields.

But the "Description" issue still remains!! How avoid auto correction in the textbox control source?