Fill Empty Cells Between Entries

[leo25031]

Hi,

I have a table which contain the clients name and on the next row it has the further details, basically I would like to fill the empty cells with the cell value (field "Client") above until a new cell value is found so it will look like:

North Bay
North Bay
North Bay
North Bay
North Bay
South Bay
South Bay..

Thank you

 

[ypma]

Have you tried using a default value in the properties of the field .

If you are using a Form
And depending when you wish the empty cells to be populated wth the word client , you could try the following in the Forms Close event procedure.:
If Me.Name of Field = "" Then
Me.Name of Feild = "Client " ' or whatever data you wish to enter
End If