Format a Criteria

[bw]

The following is my Criteria for an SQL Statement:
Like [Enter Mnemonic (use * as wildcard)]

which when executed looks like this:
Enter Mnemonic (use * as wildcard)

Just curious...is there a way to format this statement so that it would
appear on two lines like the following?

Enter Mnemonic
(use * as wildcard)

Thanks,
Bernie

 

[Marshall Barton]

The following is my Criteria for an SQL Statement:
Like [Enter Mnemonic (use * as wildcard)]

which when executed looks like this:
Enter Mnemonic (use * as wildcard)

Just curious...is there a way to format this statement so that it would
appear on two lines like the following?

Enter Mnemonic
(use * as wildcard)

Well, you can put a new line in the prompt string by using
Ctrl + Enter. But it appears that the prompt dialog box
only displays one line so it doesn't do you any good.