Add a quotation mark in the format property of a textbox.

[MatthewGrace]

I am attempting to manipulate the Format Property of a Textbox. As an example, entering in &" lbs" causes your text to end with " lbs".

... only I am trying to add a " mark, for example saying something is 6" away...



How do you tell the format property to add this?

[June7]

Don't use & character. That is to concatenate text.

Try:

#\"

[MatthewGrace]

Tried, but no luck. It appears to right justify whatever text is in the box though.

[June7]

I tested and it works for me. The Format property has no influence on alignment - that is TextAlign property.

Is this a number type field?

If you want to provide db for analysis, follow instructions at bottom of my post.

[MatthewGrace]

You're right, it does indeed work. The issue I had was that the Field in design view was listed as type "short text", however, after changing it to "number", the format of: #\" which you suggested works to add a quotation mark.

I will mark as solved. The only thing left to ask is... where did you learn about the use of the \ character in the format property. I cannot find it in the help section. Are there other character functions as well not mentioned in help?

[June7]

Somewhere along the way I encountered something like this http://office.microsoft.com/en-us/ac...001232750.aspx

The [color] parameter is new to me. Haven't tried.