SetOption in Access 2007

  • Thread starter Thread starter PaulB
  • Start date Start date
P

PaulB

Hi there,

Does anyone know if there's a possibility to set the "Check for
truncated number fields" option in Access 2007 programmatically by VBA?

I tried
Application.SetOption "Check for truncated number fields", 0
without success (error message: 2091 Invalid name).

Are there any ideas about this? Is the spelling/wording wrong, or is
this simply not possible?

Thanks,

Paul
 
I got this to work:

Sub sSetCheckTrun()
Application.SetOption "CheckTruncatedNumFields", 0
End Sub

I found it in Help by searching Set Options from Visual Basic then going
down to the Current Database tab.
 
Op 09-09-09 20:55, Jerry Whittle schreef:
I got this to work:

Sub sSetCheckTrun()
Application.SetOption "CheckTruncatedNumFields", 0
End Sub

I found it in Help by searching Set Options from Visual Basic then going
down to the Current Database tab.
Click to expand...

Hi Jerry,


Thank you for your answer. My problem is solved!


Paul
 
Back
Top