How to autocomplete a report field?

[eaglezinha]

Hello I need some help with access. In a table I have a field with text data format with 50. This field contain personal names. this is ok. I need create a report that do this:


NAME: Jonh Brightman---------------------------------------------

the name and - do 30 caracteres.


Thanks,
Eaglezinha

 

[gemma-the-husky]

nametext = left(originalname & " ------------------------------------------",50)

 

[eaglezinha]

nametext = left(originalname & " ------------------------------------------",50)

I try this in report structure text box, in mask format and do nothing.

Eaglezinha

 

[GolferGuy]

Set the Control Source of the text box to be:
=Left(FieldNameFromTableOrQuery & "---------------------------------------------", 50). Then be sure to rename the text box by putting "txt" in front of the text box name. The text box and the actual field name from the table (or query) can not be the same in this case.