# Any way to get grid format options to stick? **URL:** \ **Category:** Epicor ERP 10\ **Created:** [February 22, 2018, 10:39pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979 "2018-02-22T22:39:18Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 22, 2018, 10:39pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/1 "2018-02-22T22:39:18Z")
I’m trying to make the font size a little bigger and bold to be easier for people to read in a grid. I can change the property in the customization, and it changes upon saving. However, when re-loading the customization, they go back to the way that they were. Is there a trick to getting them to actually stay? Or do I have to set them manually in code on form load? ---
**Author:** ![jgiese.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/jgiese.wci/32/51553_2.png) [@jgiese.wci](https://www.epiusers.help/u/jgiese.wci)\ **Post date:** [February 23, 2018, 2:46pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/2 "2018-02-23T14:46:35Z")
Unless you use C# to hard code those changes or are able to make your changes in a personalization and incorporate them into your customization you’re boned. Making those sort of changes in a customization (aside from hidding and showing columns) just doesn’t work reliably. ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 23, 2018, 3:40pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/3 "2018-02-23T15:40:00Z")
Bummer, guess I have to learn some more C# today. Any good links for style control? I’ve found some with google, and I’ve tried looking through the object explorer, but it’s kind of hard to find stuff if you don’t know exactly what you’re looking for. ---
**Author:** ![jgiese.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/jgiese.wci/32/51553_2.png) [@jgiese.wci](https://www.epiusers.help/u/jgiese.wci)\ **Post date:** [February 23, 2018, 3:43pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/4 "2018-02-23T15:43:34Z")
You’ll have to parse through Infragistics website for the ultra grid control. It’s a matter of just poking through it, testing, and retesting it’s all part of the learning process. Start with a literal search in google that’s the best way to go! ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 26, 2018, 10:44pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/5 "2018-02-26T22:44:59Z")
So I figured out how to set column widths, but I cannot for the life of me figure out how to set the anchoring for the bottom and right. When I google it, it usually pops up “Use the property screen” which doesn’t work in epicor. I tried Adding this.MainGrid.Anchor = (System.Windows.Forms.AnchorStyles.Top …), for each of the sides, and it seems to anchor them now, however, the distance from the edge is too large. I think it has to do with padding right? Or do I have to get the window size as a variable so I can do the math in the customization to set the grid size correctly? Any hints would be appreciated. ![image](https://epiusers.help/uploads/default/original/2X/c/c944f40861d92e0cb731872b797835c49d2043a4.png) ---
**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\ **Post date:** [February 27, 2018, 3:51am UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/6 "2018-02-27T03:51:53Z")
Regarding the formatting, have you tried turning off UseAppStyling? Regarding anchors, they are relative to the size of the screen when you set them. So if you adjust the grid to match your form (or however you want it) manually, resizing should then affect your grid proper (assuming you’ve anchored all sides) ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 27, 2018, 3:30pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/7 "2018-02-27T15:30:19Z")
Ok, so I was able to get the size of the form to stick using the properties, and I inserted ``` this.MainGrid.Width = 1150; ``` To get the grid size to match up. So I think I am good there. > [@Chris\_Conn](#): > > Regarding the formatting, have you tried turning off UseAppStyling? I turned it off once. I looks really crappy so I turned it back on. What else would that do for me? Anyways, now I am setting up row rules. This is the line that it adds to set the style. I’m trying to figure out if I can simply set a row background color instead of a style, since the styles available are a limited list. ` RuleAction okV_PackOrNotUpdate2_1View_RowAction = RuleAction.AddRowSettings(this.oTrans, "V_PackOrNotUpdate2_1View", true, SettingStyle.OK);` Where it says “SettingStyle.ok” can I replace it with something like is suggested on this page, like Color.Red? That doesn’t work, but I can’t imagine it can be that hard can it? > **[Documentation Archives | Infragistics](https://www.infragistics.com/support/archived-documentation)** > > Find documentation for end-of-life products, including developer guides, API reference guides, and more. Frameworks include jQuery, ASP.NET, Windows Forms, and WPF. Oh, intellitype or whatever it’s called would be super helpful!!! ---
**Author:** ![markdamen](https://www.epiusers.help/user_avatar/www.epiusers.help/markdamen/32/54917_2.png) [@markdamen](https://www.epiusers.help/u/markdamen)\ **Post date:** [February 27, 2018, 8:37pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/8 "2018-02-27T20:37:15Z")
ControlSettings myControlSettings = new ControlSettings(); myControlSettings.BackColor = System.Drawing.Color.MediumSeaGreen; RuleAction warningV\_JobDashboard\_1View1\_RowAction = RuleAction.AddRowSettings(this.oTrans, “V\_JobDashboard\_1View1”, false, myControlSettings); This works for me. ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 27, 2018, 8:53pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/9 "2018-02-27T20:53:00Z")
@markdamen Thank you so much! That works great. I even found a nice list of colors to use. [http://www.flounder.com/csharp\_color\_table.htm](http://www.flounder.com/csharp_color_table.htm) ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 27, 2018, 8:59pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/10 "2018-02-27T20:59:30Z")
Do you just ignore the error that comes up about the length when you open up the customization editor? I’m assuming it has to do with the rule actions not matching the autogenerated code any more. ![image](https://epiusers.help/uploads/default/original/2X/7/72106d32ec7dfba445c49d882dca899e218918a8.png) ![image](https://epiusers.help/uploads/default/original/2X/4/4be52849b69206ac1e446cbdae88e9b15dc759f6.png) ---
**Author:** ![markdamen](https://www.epiusers.help/user_avatar/www.epiusers.help/markdamen/32/54917_2.png) [@markdamen](https://www.epiusers.help/u/markdamen)\ **Post date:** [February 27, 2018, 10:52pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/11 "2018-02-27T22:52:42Z")
Yep just been ignoring those. I get 8 pop up for all different row rules!! If you can solve that, amazing!! ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 27, 2018, 10:59pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/12 "2018-02-27T22:59:50Z")
Good to know. Do you know what the True or False does in (this.oTrans, “V\_JobDashboard\_1View1”, false, myControlSettings);? It’s set to true on the autogenerated row rules, and I’ve tried both and don’t see a difference. ---
**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\ **Post date:** [February 28, 2018, 2:24am UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/13 "2018-02-28T02:24:27Z")
It sets the GridOnly property. I guess that tells it that it isnt running the rule on underlying dataview? Not sure ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 28, 2018, 1:56pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/14 "2018-02-28T13:56:12Z")
> [@Chris\_Conn](#): > > It sets the GridOnly property. That makes sense. How can I look up what that something like that is? I’m trying to be more self reliant and being able to find what I need, but,I tried googling a bunch of stuff, parsed through the infragistics website, looked through the object explorer and could not find out anything relating to that snippet of code. There has to be better ways then “ask someone on the internet”. I’m spoiled with this group being willing to answer questions, but that only works for most things, not everything! ---
**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\ **Post date:** [February 28, 2018, 2:15pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/15 "2018-02-28T14:15:57Z")
Use a tool like ILSpy or DNSpy to decompile the appropriate DLLs in the client folder ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2018, 3:27pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/16 "2018-03-21T15:27:50Z")
> [@jgiese.wci](#): > > Unless you use C# to hard code those changes or are able to make your changes in a personalization and incorporate them into your customization you’re boned. Making those sort of changes in a customization (aside from hidding and showing columns) just doesn’t work reliably. I hate to bring this up again, but I am trying to get a grid size to stick, and even setting it using C# one of my 3 grids will not stick. I am trying to set the grid size to 1100 by 550, but every time, is loads 1171 by 575 Here’s the code to set the properties. But for some reason, the StartActivityGrid will not come is at the correct size. Am I doing something wrong? The other 2 seems to be working, but I don’t know if it’s just by dumb luck or what. ``` //this section is for formatting everying on all screens private void MainController_Load(object sender, EventArgs args) { // Add Event Handler Code //this is for setting the size of the grids this.StartActivityGrid.Width = 1100; this.StartActivityGrid.Height = 550; this.EndActivityGrid.Width = 1100; this.EndActivityGrid.Height = 550; this.PaintLabelGrid.Width = 1100; this.PaintLabelGrid.Height = 550; //this if for anchoring the grids this.StartActivityGrid.Anchor = (System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Bottom); this.EndActivityGrid.Anchor = (System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Bottom); this.PaintLabelGrid.Anchor = (System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right | System.Windows.Forms.AnchorStyles.Bottom); } ``` ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2018, 3:51pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/17 "2018-03-21T15:51:29Z")
ok. so I figured out an interesting hack. Apparently the system won’t change the grid that’s in focus. So, I added these lines around it to focus on something else, then set the properties, then focus back. ``` EndActivityGrid.Focus(); this.StartActivityGrid.Width = 1100; this.StartActivityGrid.Height = 550; StartActivityGrid.Focus(); ``` Kind of like saying “Hey what’s that!” to the computer, then changing something before it looks back. dumb… edit: Never mind, it’s not working like that. Something else that I am doing is making it stick. But I don’t know what… Now I’m having problems on the other grids… ---
**Author:** ![Mitch\_Hermes](https://www.epiusers.help/user_avatar/www.epiusers.help/mitch_hermes/32/99790_2.png) [@Mitch\_Hermes](https://www.epiusers.help/u/Mitch_Hermes)\ **Post date:** [August 8, 2018, 3:20am UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/18 "2018-08-08T03:20:17Z")
That was a wild ride. Did you ever get this working? ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [August 8, 2018, 12:58pm UTC](https://www.epiusers.help/t/any-way-to-get-grid-format-options-to-stick/42979/19 "2018-08-08T12:58:58Z")
Yeah. It’s a pretty neat solution. When a job is built or modified I have a baq looks for anything that needs to be added/changed/deleted from UD08. We then use DMT to adjust what needs adjusting (I should make a service connect workflow or powershell script or something to automate this better, but I haven’t been motivated enough to tackle that). After that, they can use this dashboard to denote whether or not the assemblers should assemble the parts or pack them loose. This merges with data from an app that we had built that checks what they have on the packing lists and what this dashboard says and tells them if there is anything that doesn’t match up. It works pretty good when everyone does what they are supposed to.