Proper Case

[jonboy]

Access 2016:
Trying to create a *Proper Case* command or StrConv in new database. Get error window with following: Enter Parameter Value ? Forum Names
Tried typing StrConv([Forum Names],3) in space. 75 years old > capital R for rookie. Any suggestions? Thanks in advance.

[Micron]

You've posted in Access (kind of general) so no clue what this is about. Query parameter prompt? VBA code re: parameter error? Something else?
In the first line of your post, Forum Names looks like a data value. In the next it looks like a field name. Maybe just replace the brackets [ ] with quotes.

[jonboy]

Micron, this is a one time project for me. Sorry, I just do not understand your questions?
Does this help any?? Tried to follow this example: https://www.youtube.com/watch?v=uMRPPBaqeoI

[Micron]

Yes, that helps. You have "Forum Names:" on the left and "Forum Names" on the right. Better if it really should be [Forum Names] - best if you don't use spaces or special characters in object names (save perhaps underscore, which I don't use). If you drag the field from the table in design view or double click on it you will get the correct name, so I'm guessing you actually have the colon in the field name. In that case, I strongly suggest you review the following:

Naming conventions - http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837

What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html

If you are not familiar with db normalization I suggest you research that also and ensure you design with these 3 things in mind (naming convention, reserved words and normalization).

[jonboy]

Micron, I really do appreciate your help and patience. Many thanks. Tried to make changes in picture 1. Results:

[mike60smart]

The field Forum Names: in table1 should just be this ForumNames with no space

Then in your query change PC:StrConv([ForumNames],3)

[Micron]

The function arguments must be wrapped in parentheses. StrConv(argument1, argument2, etc.)
Again, you are using ForumName in one place and Forum Names: in another. Access is asking you for the latter because it doesn't know what Forum Names (sans colon) is. Like I said, special characters introduce issues - get rid of them before trying anything else.

[mike60smart]

Hi
See the attached example

[CarlettoFed]

In the Query in the field

PC: StrConv([ForumNames:], 3)

you have to replace the character ',' with ';'

PC: StrConv([ForumNames:]; 3)

[isladogs]

Hi @carlettofed
No. It should be your default list separator depending on your regional settings. In the UK it is a comma. In Italy I believe its a semicolon.