How can I deal with my partner being so upset that we are having a girl and not a boy?

wow. no matter what the , it's still yalls child and he should learn to love her regardless, at least the babies healthy it could be worse some people have children with genetic defects. he really wanted a boy, so just give him time to adjust to the idea of a little girl, and when he sees that baby girl im sure hes gonna melt. i wouldnt just tell people i didnt know the because its not the you wanted, thats crazy, and i would definently have to tell my husband he needs to get over it and learn to accept it because nothings going to change the of your baby, and i would hope he would love the child anyways, and im sure your family will.