General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Tom,
Firstly, If your variable is called SuperId, you can not query the type in this way. It has to be braced in quotes:
thisform.text1.value = type('superid')
alternatively you can use:
thisform.text1.value = vartype(superid).
Still, i don't see what this achieves to help you achieve what you were doing in your earlier example. In that example it was clear that SuperId would be a string. The problem is that thisform.text1.value is not a string or your field was not of type string.
To fix it, you have two choices.
1. Either cast the values of thisform.text1 and your field into strings using transform or
2. Type the variable SuperId correctly.
Let me know how you get on.
Mace
>Thanx Guy
>
>I have tried using transform, but still not working for some reason. I even tried to use something like
>
>superid = transform(superid)
>thisform.text1.value = type(superid)
>
>it still returns a U and my program does work ahhh
>is there a reason why it locks down?
>
>Tom
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only