When I used to add new data in my form a blank row is added whether I have saved it or not how can I remove empty rows from my Grid.
Also I have set datatsource "Insert if empty" property to No.
.
Martin,
Thanks, this quite helped me .
If you don't want several new rows, simply don't create them.
For example, if you press New button three times, you'll get three rows. If you want just one, press the button just once and not three times.
Hi Deepak,
I just want to restrict empty rows appearance and don't want them to appear again .
if I haven't added any data why are these empty rows suppose to appear?
I hope you understand what I am saying!
Hi Junaid,
Initially you asked how to delete these rows, which I guess sorted now. I am bit confused when you asking to control empty rows, what exactly you are trying to achieve.
hi Andre,
I do have a delete button and yes you are right it disappears when I delete or refresh it , but is there any way from which I can control these empty rows?
Hi JJDunaid,
It is expected behavior that there will be a new row added when you click on NEW. When you don't make any changes, then indeed the records will not be inserted in the database.
If you have an action button for Delete on your form, you can use this to remove it without refreshing. A shortcut for this action is Alt+Delete.
Martin,
YES ,It adds blank rows the number of times I click on NEW , but I never saved any of it.
but when I refresh it ,the extra blank rows disappears.
Are you saying that you can create a new row, don't save it and create an extra row? And if you don't save either and refresh the form, these records won't be there?
This is the standard behavior of F&O grids, isn't it?
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156