Clearing values from only one bound column in Form (1 Viewer)

[zacox]

I have been searching this forum and the web in whole, high and low for the solution to this and have found nothing. I am stuck.

I have a form bound to a certain table. I print this form for use during a hand-count where I manually write in values then type them into the form after the hand count is finished. I want blank fields on the print out.

Specifics about the form and issue:

• Five bound fields, four of them disabled and locked, one enabled and unlocked.
• Data Entry flag solution not applicable because I need the locked fields to remain; I'm just updating current records and not entering new ones.
• acTextBox ctl.Value method returns an error, but would clear all text boxes upon execution.
• Me.Fieldname = Null on If/Then doesn't work.

Any ideas?

Thanks.

 

[zacox]

Never mind all that!

Turns out I am an idiot, and i realised this as soon as i typed UPDATE in the previous post....

UPDATE [Count Aggregate] SET [Count Aggregate].[Actual Number Counted] = Null;

Durrrrrr

 

[John Big Booty]

Try

If Isnull(Me.Fieldname) Then
     Do your thing
End If

 

[John Big Booty]

Ignore me

 

[zacox]

I've been using Access for a grand total of 2 weeks, and the one thing i have learned in those two weeks is that there is usually at least two ways of doing something. Sometimes there are an unlimited number of methods depending on how inefficient you want to be.

I think i could have chosen a much simpler and more benign database to create for my first one, though!