Can you put reasonable limits on fields in Access?

[Guest]

For example if I know the value to be entered into a field should be between
..010 and .100, can you set the field up to not accept a value that is out of
this range?

 

[Guest]

Set the field's ValidationRule property in table design view to:

=0.010 And <=0.100

Ken Sheridan
Stafford, England

 

[Guest]

Yes. A very simple example, without error trapping:

Private Sub urFieldname_BeforeUpdate

If Me.urFieldname < .010 or Me.urFieldname > .100 Then
Msgbox "You can't do that, pal."
Else: Exit Sub
End If

End Sub

 

[Granny Spitz via AccessMonster.com]

if I know the value to be entered into a field should be between
.010 and .100, can you set the field up to not accept a value that is out of
this range?

Open the table in design view and click on the column you want to restrict.
Place this in the Validation Rule property:

Between 0.01 And 0.1

Place this in the Validation Text property:

The amount must be between 0.01 and 0.1.

 

[Guest]

You should also set the return value of the Cancel argument to True if the
criteria are not met when validating at control level in the BeforeUpdate
event procedure.

Ken Sheridan
Stafford, England