Format a default suffix to a text field in a form

Diana van den Berg
4StarLounger
Posts: 582
Joined: 06 May 2012, 20:05

Format a default suffix to a text field in a form

Post by Diana van den Berg »

Is there a text equivalent of the following?

0\G

The above is the default format for the number of GBs in a number field in a form.

I would like _MC to be added to a certain text field in a form.

Thank you for any help.

User avatar
HansV
Administrator
Posts: 78589
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Format a default suffix to a text field in a form

Post by HansV »

You can use the format

@"_MC"

for this purpose. The _MC will only be added if the text box/field contains a value, otherwise it will be suppressed.
Best wishes,
Hans

Diana van den Berg
4StarLounger
Posts: 582
Joined: 06 May 2012, 20:05

Re: Format a default suffix to a text field in a form

Post by Diana van den Berg »

Stunning! Thank you, Hans!