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

[missinglinq]

I'm afraid your question isn't very clear; your explanation and your example don't match up! Do you want you

1. Name and a string of 30 dashes
2. Name and enough dashes to fill out the 50 character string?

In either case, you need to place an unbound textbox on your report and enter this as its Control Source

For Option 1 above

=[FullName] & String(30,"-")

For Option 2 above

=[FullName] & String(50-Len([FullName]),"-")


Welcome to TheScripts!

Linq ;0)>