SetOption in Access 2007

[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

 

[Jerry Whittle]

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.

 

[PaulB]

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.

Hi Jerry,


Thank you for your answer. My problem is solved!


Paul