controlling text field in datasheet view

[BitZero]

I'm using a form with datasheet view to update and add records to a table. This form has an unbound text box, and I want to control the properties of this text box based on me.NewRecord. If me.NewRecord is true, I want the text box to have a blank value. If false, I want the text box to have a value of "Edit". What event do I put this logic in?
Thanks

 

[dhookom]

datasheet view ... unbound text box

this doesn't allow or provide a different value for each record/row. The same value will display for all displayed records.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

BitZero . . .

dhookom is correct. I was thinking the textbox had to be in the forms header or footer, but these sections don't show in datasheet view either.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[BitZero]

AceMan and dhookom - thanks for your replies. I was able to figure out a way around it. Since the data record source for the form is a query, I added a dummy field in the select, like this:

select "Edit" as edit_id, field1, field2, etc

The word "Edit" now shows up on every existing record, but not on the blank new record line.

Thanks again. See Ya!