How to split date and time in datasheet

[projecttoday]

I am trying to create a datasheet subform which is bound to a table which has a date/time field in it. What I want to do is split the date/time field into 2 cells on the form, one for date and one for time while at the same time updating the single field in the table. So for the date portion, if I use =iif([flddatetime],"",[flddatetime]) as the record source combined with a format of Short Date, it displays okay but the cell is not enterable. If I move it to the default value of the control, the same wrong value appears in every row. Anybody have any suggestions on how to manipulate date/time parts on a datasheet?

 

[dhookom]

I am not optimistic that you could do this. The date and time text boxes would need to be unbound. These would all display the same value for every record in the form. You would need code to update the bound datetime text box.

Duane
Hook'D on Access
MS Access MVP

 

[projecttoday]

So if I make an entry into an unbound textbox, it propagates throughout the rows? Is there any way to prevent that?

 

[dhookom]

Not that I am aware of. Try it to see if your experience varies.

Duane
Hook'D on Access
MS Access MVP

 

[projecttoday]

Okay.