Text convertion

[Sylviajb]

Good day,
I'm having trouble converting text to proper text in Access 2010 using Windows 8.1 as OS. The message I keep getting is:
The expression you entered contains invalid syntax
You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks
the formula I use is:
strconv([field],3)
Please assist.
Thanks

 

[Ranman256]

strconv([field],3) is correct, but did you assign it?
if its in a query then it is fine.

Where are you using it?

 

[Sylviajb]

Yes I did assign it. I tried it as a new field in a query as well as an update query. got the same message with both. When I used Windows 8 I did not encounter this problem. It's only since I upgraded to 8.1 that this occurred.

 

[CJ_London]

what is the name of the field you are trying to convert? I presume it is not 'field' since it is a reserved word. If it is 'field' then that may be generating the error

 

[vbaInet]

Perhaps you should copy and paste the full SQL of the query.

 

[jdraw]

Please post the code involved. We can't give a focused response without seeing what you have.

 

[spikepl]

Now since this is a party for all ...

Too me it smells like data ... what is the content of that actual field. Supply that too.

 

[The_Doc_Man]

Worked in Win8, failed in Win8.1 - smells vaguely of a .DLL problem. Check for broken references.