Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting properties

Status
Not open for further replies.

ncvdac

Programmer
Oct 30, 2001
7
US
I have a form created using word.

I created several fields and put in a maximum length in the properties box.

Can I get that maximum length using a macro?

I need to ensure the fields are a certain length and need to pad with spaces to fill out the field.

Thanks,

Dan
 
Not sure if this is what you're trying to do, but if you want to check the length of the user input, use: LEN(expression)
 
I know how to get the length of the user input. What I need is the maximum number of characters allowed in a bookmark. For example, If the user types CAT, I know it is 3. If the bookmark has a max lenth of 8, I need to get that I need to pad the entry with 5 spaces. I do not know how to programatically get the 8. I could hard code, but I have over 600 templates to write this macro for and each has a different fields and field lengths.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top