Access - Attachmate IF Then Statement

[NWildblood]

Hi, I'm running some jobs from Access in Attachmate, and need a simple VB If ... Then statement to either populate a field or move over it if the field is already populated - what's the easiest syntax to use to determine If the field is already populated ?

Many thanks, not a coder, I just use VB to automate tasks.

"No-one got everything done by Friday except Robinson Crusoe...

 

[dam0612]

Hi

I'm no expert either but I use the like of:

Test = MyScreen.GetString (1, 1, 1)
If Test = " " then
Code in here for test = " "
Else: Code in here for Test is not = " "
End if

but I'm sure there is a better way

good luck